centos 设置mysql可以远程访问

centos 设置mysql可以远程访问

GRANT ALL  PRIVILEGES ON *.* TO 'root'@'%'IDENTIFIED BY 'mypassword' WITH GRANT OPTION;    
flush  privileges; 

不区分大小写

[root@test-huanqiu ~]# vim /etc/my.cnf //添加下面一行设置
....
[mysqld]
lower_case_table_names=1
.....

[root@test-huanqiu ~]# /etc/init.d/mysql restart //重启mysql