Centos6.5下修改mysql遠端登陸權限

Linux 安裝Mysql資料庫後，通過遠端連接配接mysql時報erro 2003: Can't connect to MySQL server on '*.***.***' (111)，解決方法如下：

1.[root@mysql ~]# mysql -u root p       #登陸mysql

2.mysql> grant all PRIVILEGES on *.* to 'root'@'%'indentified by 'beauty' with grant option;

3. mysql> FLUSH PRIVILEGES

4. mysql> quit