软件开发培训班 >> 编程开发 >> MySQL


给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;