使用root用户登录数据库,然后执行下面的命令:
grant all privileges on *.* to 'user'@'%' identified by 'password' with grant option;
user是要开通远程登录权限用户,password的密码,例如:
grant all privileges on *.* to 'root'@'%' identified by '123456' with grant option;
使用root用户登录数据库,然后执行下面的命令:
grant all privileges on *.* to 'user'@'%' identified by 'password' with grant option;
user是要开通远程登录权限用户,password的密码,例如:
grant all privileges on *.* to 'root'@'%' identified by '123456' with grant option;