linux下添加用户访问权限

1.创建用户

mysql> CREATE USER 'root'@'%' IDENTIFIED BY 'password'; 

3.查看当前用户权限

mysql> show grants;

4.查看其他用户权限

mysql> show grants for root@'%';

2.给用户添加root权限

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION

mysql> GRANT PROXY ON ''@'' TO 'root'@'%' WITH GRANT OPTION