Mysql添加远程访问用户

2021-11-20 00:00:00 mysql remote-access

我用 password 'password 创建了用户 user@'%'.但我无法连接:

I created user user@'%' with password 'password. But I can not connect with:

mysql_connect('localhost:3306', 'user', 'password');

当我创建用户 user@'localhost' 时，我能够连接.为什么?'%' 不是来自任何主机吗?

When I created user user@'localhost', I was able to connect. Why? Doesn't '%' mean from ANY host?

推荐答案

为了远程连接，您必须让 MySQL 将端口 3306 绑定到 my.cnf 中您机器的 IP 地址.然后，您必须在 localhost 和 '%' 通配符中创建用户并授予对所有数据库的权限，例如.见下文:

In order to connect remotely you have to have MySQL bind port 3306 to your machine's IP address in my.cnf. Then you have to have created the user in both localhost and '%' wildcard and grant permissions on all DB's as such . See below:

my.cnf(Windows 上的 my.ini)

my.cnf (my.ini on windows)

#Replace xxx with your IP Address 
bind-address        = xxx.xxx.xxx.xxx

然后

CREATE USER 'myuser'@'localhost' IDENTIFIED BY 'mypass';
CREATE USER 'myuser'@'%' IDENTIFIED BY 'mypass';

然后

GRANT ALL ON *.* TO 'myuser'@'localhost';
GRANT ALL ON *.* TO 'myuser'@'%';
flush privileges;

根据您的操作系统，您可能需要打开端口 3306 以允许远程连接.

Depending on your OS you may have to open port 3306 to allow remote connections.

相关文章