# 开启zxa用户的远程登录权限
#123456为密码
grant all privileges on *.* to zxa@"%" identified by "123456";
# 刷新权限
flush privileges;
#查看一下用户权限,Host处变为%
select User,Host from mysql.user;
#设置完成!重新连接就能连上了!
# 开启zxa用户的远程登录权限
#123456为密码
grant all privileges on *.* to zxa@"%" identified by "123456";
# 刷新权限
flush privileges;
#查看一下用户权限,Host处变为%
select User,Host from mysql.user;
#设置完成!重新连接就能连上了!