麻烦在MySQL Workbench中创建连接

I am using Fedora 18 and recently installed MySQL workbench. I created a new connection in MySQL workbench, but when trying to open I get the following error:

我正在使用Fedora 18并且最近安装了MySQL工作台。我在MySQL工作台中创建了一个新连接,但是在尝试打开时我收到以下错误:

Cannot Connect to Database Server

无法连接到数据库服务器

Your connection attempt failed for user 'root' from your host to server at 127.0.0.1:3306: Can't connect to MySQL server on '127.0.0.1' (111)

在127.0.0.1:3306,用户“root”从主机到服务器的连接尝试失败:无法连接到“127.0.0.1”上的MySQL服务器(111)

Please:

1. Check that mysql is running on server 127.0.0.1

检查mysql是否在服务器127.0.0.1上运行

2. Check that mysql is running on port 3306 (note: 3306 is the default, but this can be changed)

检查mysql是否在端口3306上运行(注意:3306是默认值,但可以更改)

3. Check the root has rights to connect to 127.0.0.1 from your address (mysql rights define what clients can connect to the server and from which machines)

检查root是否有权从您的地址连接到127.0.0.1(mysql权限定义哪些客户端可以连接到服务器以及从哪些计算机连接)

4. Make sure you are both providing a password if needed and using the correct password for 127.0.0.1 connecting from the host address you're connecting from

确保您在需要时提供密码并使用正确的密码127.0.0.1从您连接的主机地址连接

Any idea what the issue would be?

知道问题是什么吗?

1 个解决方案

#1

Fedora 18 is a Linux Based Operating System and it works on chmod 777. so there should be authentication problem. otherwise server 127.0.0.1 and host name , username same as we keep in windows. you need to set authentication.

Fedora 18是基于Linux的操作系统,它适用于chmod 777.因此应该存在身份验证问题。否则服务器127.0.0.1和主机名,用户名与我们在Windows中保存的相同。你需要设置身份验证。