远程访问CENTOS的MYSQL数据库设置

远程访问CENTOS的MYSQL数据库设置

mysql -u root -p

grant all privileges on *.* to root@'%'identified by 'root';  
后面的root是root用户的密码

grant all privileges on *.* to root@'localhost'identified by 'root';  

mysql -u root -p