非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;
非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;