Linux找到my.cnf文件
修改解决大小写问题
在文件中补充: lower_case_table_names=1
伦理片 http://www.dotdy
.com/
重启Mysql生效
- # find / -name my.cnf
修改解决大小写问题
在文件中补充: lower_case_table_names=1
- [mysqld]
- datadir=/var/lib/mysql
- socket=/var/lib/mysql/mysql.sock
- user=mysql
- # Disabling symbolic-links is recommended to prevent assorted security risks
- symbolic-links=0
- lower_case_table_names=1
- [mysqld_safe]
- log-error=/var/log/mysqld.log
- pid-file=/var/run/mysqld/mysqld.pid
重启Mysql生效
- #service mysqld start
- #service mysqld stop