我猜我可能忘了某些显而易见的东西,但似乎无法使用MySQL连接127.0.0.1
。 通过localhost
连接可以工作。
MySQL / Linux版本:Server version: 10.0.31-MariaDB-0ubuntu0.16.04.2 Ubuntu 16.04
这个是有效的:
$ mysql -h localhost -u root
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 71982
Server version: 10.0.31-MariaDB-0ubuntu0.16.04.2 Ubuntu 16.04
Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]>
这种方法是行不通的:
$ mysql -h 127.0.0.1 -u root
ERROR 1698 (28000): Access denied for user 'root'@'localhost'
据我所知,MySQL正在监听 127.0.0.1:3306
:
$ netstat -plnt
Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
tcp 0 0 127.0.0.1:3306 0.0.0.0:* LISTEN 1841/mysqld
我甚至可以使用 Telnet 连接到 3306 端口:
$ telnet 127.0.0.1 3306
Trying 127.0.0.1...
Connected to 127.0.0.1.
Escape character is '^]'.
j
5.5.5-10.0.31-MariaDB-0ubuntu0.16.04.2TGYk-=,d5-??wz}'Hr*s+u24mysql_native_password
以防万一,我也为主机127.0.0.1创建了一个具有授权选项的用户:
mysql > CREATE USER 'root'@'127.0.0.1' IDENTIFIED BY '<redacted>';
mysql > GRANT ALL PRIVILEGES ON *.* TO 'root'@'127.0.0.1' WITH GRANT OPTION;
以下是关于用户的一些信息(由@brian-ecker建议查询):
MariaDB [(none)]> SELECT User, Host, plugin FROM mysql.user;
+------------------+-----------+-------------+
| User | Host | plugin |
+------------------+-----------+-------------+
| root | localhost | unix_socket |
| root | 127.0.0.1 | |
+------------------+-----------+-------------+
我也尝试创建一个使用unix_socket标识的root用户,但没有帮助:
MariaDB [(none)]> CREATE USER 'root'@'127.0.0.1' IDENTIFIED VIA unix_socket;
MariaDB [(none)]> GRANT ALL PRIVILEGES ON *.* TO 'root'@'127.0.0.1' WITH GRANT OPTION;
MariaDB [(none)]> SELECT User, Host, plugin FROM mysql.user;
+------------------+-----------+-------------+
| User | Host | plugin |
+------------------+-----------+-------------+
| root | localhost | unix_socket |
| root | 127.0.0.1 | unix_socket |
+------------------+-----------+-------------+
你有什么建议,为什么我可以通过“localhost”连接,但无法通过“127.0.0.1”连接?
mysql -h 127.0.0.1 -u root -p
。当你使用localhost
进行连接时,MySQL 尝试使用套接字进行连接,但是当你连接到127.0.0.1
时,它使用 tcp 进行连接,而且权限甚至可以针对localhost
和127.0.0.1
分别设置,所以也许127.0.0.1
设置了密码,但是localhost
不需要密码? - Brian Eckermysql -h 127.0.0.1 -u root -p
返回:输入密码:
当我输入密码后,我看到这个错误信息:ERROR 1698 (28000): 用户'root'@'localhost'被拒绝访问
。 - simentSELECT User、Host、plugin FROM mysql.user;
? - Brian Ecker