MYSQL WorkBench未连接到数据库 [英] MYSQL WorkBench Not Connecting to Database

问题描述

MySQL工作台未连接到本地主机中的服务器.

MySQL workbench is not connecting to server in localhost.

但是，我能够使用命令行进行连接.现在，工作台和命令提示符中的访问被拒绝.

But, I was able to connect using command line. Now access denied in workbench and command prompt.

尝试重新安装Mysql，这是第一次运行.系统(计算机)重新启动后，其不再起作用.

tried re-install Mysql, its working first time. after system (computer) restart, its not working again.

试图使用Workbench 5.2进行连接.

Tried to connect using workbench 5.2.

我的安装有什么问题，或者我需要在Mysql中做任何事情.

what is wrong with my installation or do i need to do any thing in Mysql.

我正在使用Windows 8.1

I am using windows 8.1

推荐答案

仅当您连接到本地主机时，此方法才有效.

This works only if you are connecting to localhost.

使用127.0.0.1作为主机名，或直接键入"localhost"，而Mysql服务器端口为3306. 和 确保用户名后面没有空格.有时可能会给您带来麻烦.

Use 127.0.0.1 as you hostname or simply type in "localhost" and Mysql server port being 3306. And Make sure there are no spaces after username. It might sometime cause you trouble.

这篇关于MYSQL WorkBench未连接到数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！