Can't connect to MySQL server on 'localhost' (10061) after Installation

Question

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

I have gone through this page, it told me to find the error log (.err) in C:\Program Files\MySQL\MySQL Server 5.5\data. This directory exists but there is no log file.

I am thinking this is related to the tight security of Windows 7, especially when installing a Unix based software. 

Any help or suggestions is appreciated. 

Answer 1

This issue is very easy to solve by windows server users.

1. Go to this path C:\Program Files\MySQL\MySQL Server 5.1\bin

2. Run this tool "MySQLInstanceConfig.exe"

Then config the instance again and the problem will be solved.

Interested in SQL ? Check out this SQL Certification by Intellipaat.

For more information visit :