Linux设置mysql远程访问

非root用户获取root权限

su - root

登录mysql

root#mysql -h localhost -uroot -p

mysql> use mysql;

mysql> select host,user from user;

mysql> Grant all privileges on *.* to 'root'@'%' identified by 'pwd' with grant option;
mysql> flush privileges;