设置用户数据库并授权

创建数据库用户,并且授予luffyapi这个库的权限

# 新建luffyapidb数据库
create database luffyapidb		

# 给luffyapi用户授权使用luffyapidb数据库的权限:远程+本地,【密码:Luffy123?】
grant all privileges on luffyapidb.* to 'luffyapi'@'%' identified by 'Luffy123?';
grant all privileges on luffyapidb.* to 'luffyapi'@'localhost' identified by 'Luffy123?';

# 刷新授权
flush privileges;
posted @ 2020-07-19 12:25  the3times  阅读(205)  评论(0)    收藏  举报