设置用户数据库并授权
创建数据库用户,并且授予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;