《Mysql实例给Mysql添加远程访问权限的方法》要点:
本文介绍了Mysql实例给Mysql添加远程访问权限的方法,希望对您有用。如果有疑问,可以联系我们。
user:myuser pwd:mypassword 从任何主机连接到mysql服务器MYSQL数据库
GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'%' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;MYSQL数据库
user:myuser pwd:mypassword 从192.168.1.3连接到mysql服务器MYSQL数据库
GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'192.168.1.3' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;MYSQL数据库
转载请注明本页网址:
http://www.vephp.com/jiaocheng/1674.html