蓝队云 - 领先的云服务器、服务器租用托管、域名注册提供商

Mysql添加远程访问权限的方法

2015-09-07 16:51:34 12802次

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;