一、连上数据库
mysql -uroot -pyourpassword
二、添加用户
mysql> CREATE USER 'add_user_name'@'%' IDENTIFIED BY 'add_user_password';
Query OK, 0 rows affected (0.01 sec)
三、设置某个库的权限
mysql> GRANT ALL PRIVILEGES ON 数据库名称.* TO 'add_user_name'@'%' IDENTIFIED BY 'add_user_password';
Query OK, 0 rows affected, 1 warning (0.00 sec)
四、刷新权限
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.03 sec)