远程连接mysql 授权方法详解-php手册-php.cn

Home

php教程

php手册

远程连接mysql 授权方法详解

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Jun 07, 2016 am 11:37 AM

远程连接mysql 授权方法详解

远程连接MYSQL提示Host '192.168.0.34' is not allowed to connect to this MySQL server
如果你想连接你的mysql的时候发生这个错误：

ERROR 1130: Host '192.168.1.3' is not allowed to connect to this MySQL server

1。改表法。可能是你的帐号不允许从远程登陆，只能在localhost。这个时候只要在localhost的那台电脑，登入mysql后，更改 "mysql" 数据库里的 "user" 表里的 "host" 项，从"localhost"改称"%"mysql -u root -pvmwaremysql>use mysql;<br> mysql>update user set host = '%' where user = 'root';<br> mysql>select host, user from user;2. 授权法。例如，你想myuser使用mypassword从任何主机连接到mysql服务器的话。

GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'%' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;
如果你想允许用户myuser从ip为192.168.1.3的主机连接到mysql服务器，并使用mypassword作为密码GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.0.34' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;重点：mysql>flush privileges; 这句一定要加上！！！

AD：真正免费，域名+虚机+企业邮箱=0元

Statement

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn