(1) 登录root用户
mysql -u root -p;
(2) 创建自定义数据库 db_name
create database db_name;
(3) 创建自定义用户 test_user
create user test_user@'localhost' identified by 'password';
(4) 修改密码为 caspassword,此步骤可省略
set password for 'test_user'@'localhost'= 'caspassword';
(5) 给用户 test_user 授予管理数据库 db_name 的所有权限
grant all privileges on db_name.* to test_user;
说明:
授权时可能出现以下问题:
You are not allowed to create a user with GRANT;
解决方案:
将用户test_user改为允许远程连接,即将localhost改为%
update user set host='%' where user='test_user ';
更改为远程连接后依然提示:
ERROR 1410 (42000): You are not allowed to create a user with GRANT
解决方案:
1、切换到test_user用户所属的数据库
use db_name;
2、再执行授权
grant all privileges on db_name.* to test_user;
二、查看是否授权成功
show grants for test_user;