#注意在本地的数据库执行以下代码 jmfs是数据库,账号是jiaming 密码是jiaming
# 允许本地 IP 访问 localhost, 127.0.0.1
insert into mysql.user (Host,User,Password,ssl_cipher,x509_issuer,x509_subject) values("localhost","jiaming",password("jiaming"),'','','');
# 允许外网 IP 访问
insert into mysql.user (Host,User,Password,ssl_cipher,x509_issuer,x509_subject) values("%","jiaming",password("jiaming"),'','','');
# 刷新授权
flush privileges;
# 授予用户通过外网IP对于该数据库的全部权限
grant all privileges on jmfs.* to jiaming@'%' identified by 'jiaming' WITH GRANT OPTION;
# 授予用户在本地服务器对该数据库的全部权限
grant all privileges on jmfs.* to jiaming@localhost identified by 'jiaming' WITH GRANT OPTION;
# 刷新权限
flush privileges;