安装后无法连接到“localhost"(10061)上的 MySQL 服务器

Can#39;t connect to MySQL server on #39;localhost#39; (10061) after Installation(安装后无法连接到“localhost(10061)上的 MySQL 服务器)
本文介绍了安装后无法连接到“localhost"(10061)上的 MySQL 服务器的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我在 Windows 7 上使用 mysql-installer-5.5.20.0.msi 安装了 MySQL.在 cmd 窗口中,我运行mysqlshow -u root -p".它要求输入密码,然后返回此错误:无法连接到 'localhost' (10061) 上的 MySQL 服务器"这是部分失败/成功安装的不良指示.

I installed MySQL using mysql-installer-5.5.20.0.msi on Windows 7. From the cmd window, I run "mysqlshow -u root -p". It asked for a password, then returned this error: "Can't connect to MySQL server on 'localhost' (10061)" This is a bad indication of partially failed/successful installation.

阅读页面后,http://dev.mysql.com/doc/refman/5.5/en/windows-troubleshooting.html,它告诉我在 C:Program FilesMySQLMySQL Server 5.5data 中找到错误日志 (.err).目录存在但没有日志文件.

After reading the page, http://dev.mysql.com/doc/refman/5.5/en/windows-troubleshooting.html, it told me to find an error log (.err) in C:Program FilesMySQLMySQL Server 5.5data. The directory exists but there is no log file.

我感觉这与 Windows 7 的严格安全性有关,尤其是在安装基于 Unix 的软件时.是的,我是我电脑上的管理员.

I have a feeling this is related to the tight security of Windows 7, especially when installing a Unix based software. And yes, I am the Administrator on my PC.

感谢任何帮助或建议.而且我可以通过回答 Java 和 SQL 查询问题来报答你.

Any help or suggestions is appreciated. And I can return a favor by answering Java and SQL query questions.

推荐答案

这个问题非常需要windows server用户解决

this issue is very to solve by windows server users

  1. 去这条路C:Program FilesMySQLMySQL Server 5.1in

  1. go to this path C:Program FilesMySQLMySQL Server 5.1in

运行这个工具MySQLInstanceConfig.exe"

run this tool "MySQLInstanceConfig.exe"

然后重新配置实例,问题就解决了

and config the instatnce again and problem solved

这篇关于安装后无法连接到“localhost"(10061)上的 MySQL 服务器的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持编程学习网!

本站部分内容来源互联网,如果有图片或者内容侵犯您的权益请联系我们删除!

相关文档推荐

Hibernate reactive No Vert.x context active in aws rds(AWS RDS中的休眠反应性非Vert.x上下文处于活动状态)
Bulk insert with mysql2 and NodeJs throws 500(使用mysql2和NodeJS的大容量插入抛出500)
Flask + PyMySQL giving error no attribute #39;settimeout#39;(FlASK+PyMySQL给出错误,没有属性#39;setTimeout#39;)
auto_increment column for a group of rows?(一组行的AUTO_INCREMENT列?)
Sort by ID DESC(按ID代码排序)
SQL/MySQL: split a quantity value into multiple rows by date(SQL/MySQL:按日期将数量值拆分为多行)