Welcome

首页 / 数据库 / MySQL / 给Mysql添加远程访问权限的方法

user:myuser  pwd:mypassword 从任何主机连接到mysql服务器
GRANT ALL PRIVILEGES ON *.* TO "myuser"@"%" IDENTIFIED BY "mypassword" WITH GRANT OPTION;
user:myuser  pwd:mypassword 从192.168.1.3连接到mysql服务器
GRANT ALL PRIVILEGES ON *.* TO "myuser"@"192.168.1.3" IDENTIFIED BY "mypassword" WITH GRANT OPTION;