用户root无法在127.0.0.1:3306连接到MySQL [英] Failed to Connect to MySQL at 127.0.0.1:3306 with user root

问题描述

我在mysql workbench中有连接数据库服务器的错误



无法使用root用户在127.0.0.1:3306连接到MySQL



在''读取初始通信包'时失去与MySQL服务器的连接，系统错误：111





现在我使用linux ubunutu操作系统，请给我sugesstion，因为它无法连接到服务器......

请给我建议...... ..

I have an error in mysql workbench for connect to the database server

Failed to Connect to MySQL at 127.0.0.1:3306 with user root

Lost connection to MySQL server at ''reading initial communication packet'', system error: 111


Now i using linux ubunutu operating system and please give me sugesstion for that can''t connect to server......
Please give me suggestion........

推荐答案

1。检查MySQL服务器是否已安装并运行

2.检查MySQL服务器是否配置为侦听除Linux域套接字连接之外的TCP连接

3.检查MySQL用户root（与Linuxroot不一样！）有权从主机127.0.0.1连接到数据库

1. Check that the MySQL server is installed and running
2. Check that the MySQL server is configured to listen for TCP connections in addition to Linux domain socket connections
3. Check that the MySQL user "root" (not the same as Linux "root"!) has the right to connect to the database from host 127.0.0.1

检查你是否正在使用正确的mysql连接器jar在classpath。

check whether u are using correct mysql connector jar in classpath.

这篇关于用户root无法在127.0.0.1:3306连接到MySQL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！