Intellipaat Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
in SQL by (6.1k points)

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. 

1 Answer

0 votes
by (12.7k points)

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 :

Related questions

0 votes
1 answer
asked Dec 15, 2020 in SQL by Appu (6.1k points)
0 votes
1 answer

31k questions

32.8k answers

501 comments

693 users

Browse Categories

...