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

问题描述

我使用Mysql Workbench连接数据库，[

I use Mysql Workbench to connect my database,[

主机名端口和用户名如图所示，密码正确.当我单击测试连接"时，如上所示.但是如果我使用3307代替3306作为端口，则表示连接成功.到底是什么原因导致的，我该如何解决?

Hostname Port and Username are as shown in figure ,and password is right.When I click Test Connection ,it show as above.But if i use 3307 in place of 3306 as port,it connect sucessfully. What matter lead that and how I fix it?

我使用的是macbook pro，但我不知道检查哪个my.cnf.我在终端中使用sudo vim/usr/local/mysql/my.cnf.
而my.cnf如下:

I use macbook pro and I don't know check which my.cnf. I use sudo vim /usr/local/mysql/my.cnf in terminal .
And the my.cnf is as below:

[mysqld] 
 sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES            

我将其重述如下:

[client]
port=3306
socket=/tmp/mysql.sock

[mysqld]
port=3306
socket=/tmp/mysql.sock
key_buffer_size=16M
max_allowed_packet=8M 
[mysqldump]
quick 

但是它不起作用.

推荐答案

步骤:

1-右键单击在任务栏上-> 启动任务管理器

1 - Right click on your task bar -->Start Task Manager

2-点击在服务按钮(位于底部)上.

2 - Click on Services button (at bottom).

3-搜索 MYSQL57

4-右键单击在MYSQL57上-> 开始

4 - Right Click on MYSQL57 --> Start

再次开始您的 mysql-cmd提示或 MYSQL WorkBench

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