简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)
Home > Database > Mysql Tutorial > body text

有关于mysql 在linux下去分表名大小写的问题_MySQL

WBOY
Release： 2016-06-01 13:37:35
Original
836 people have browsed it

bitsCN.com

我做开发时候是用windows 的   所以没感觉 

今天部署自己做的一个yii 项目到linux的时候发现的一个问题，

yii 的rbac 的表找不到   报错如下

 

CDbCommand 无法执行 SQL 语句: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'si_manager.AuthAssignment' doesn't exist. The SQL statement executed was: SELECT * FROM `AuthAssignment` WHERE userid=:userid

 

但是我去看我linux的机器是有这个数据表的

image

仔细看提示，是大小写略微不同，之后手工执行出错的语句，同样报错，于是确定是大小写问题   

 

于是google   得知mysql在linux下表名是去分大小写的     只不过有配置改成不区分   非常简单

 

在/etc/my.cnf 里的[mysqld] 下面增加lower_case_table_names=1 这一句话即可

image

bitsCN.com
Related labels：
linux mysql windows develop
source：php.cn
Previous article：更改MySQL的默认字符集方法集锦_MySQL Next article：SQL&MySQL查询添加字段为行号_MySQL
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
XAMPP/SQLSRV: Unable to find Sqlsrv in PHPINFO(); - error from connection I'm trying to connect to my SQLServer database hosted on a LinuxVM. I'm running xampp on m...
From 2023-11-09 22:34:33
0
1
172
"'vue-cli-service@latest' is missing from Windows npm registry but works fine in WSL" I have a Vue app that I'm trying to run using npmrunstart, but when I run the command from...
From 2023-11-07 10:01:47
0
1
290
When using Laravel on Ubuntu, an unsupported property was specified on the PDO object: MSSQL My UbuntuvagrantLaravelHomestead setup is configured to connect to MSSQL. Randomly, it sta...
From 2023-10-30 23:05:50
0
1
256
Why do I get the "data source name not found and no default driver specified" message and how do I fix it? When trying to write a program on Windows that connects to a database via ODBC, I get the ...
From 2023-10-18 13:56:36
0
2
202
How to add existing schema to mysql on windows I haven't seen anything about this topic anywhere, not even here. The problem is that I ha...
From 2023-09-14 13:51:44
0
1
210
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn：Public welfare online PHP training，Help PHP learners grow quickly！