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

mysql windows windows-7
The Original Android picture The Original Android · Jun 5, 2012 · Viewed 386.9k times · Source

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.

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 Files\MySQL\MySQL Server 5.5\data. The directory exists but there is no log file.

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.

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

Answer

maheshDeshmukh picture maheshDeshmukh · Jan 19, 2016

Please Try the following steps:

  1. c:\mysql\bin>mysqld --install
  2. c:\mysql\bin>mysqld --initialize

then press "Windows key + R" write "services.msc", run as admin

start MySQL service.

Related questions

How to log in to phpMyAdmin with WAMP, what is the username and password?

What does the word "root" mean in phpMyAdmin? Whenever I write localhost/phpmyadmin on the address bar, I am asked to enter a username and a password, but I don't know what they are. I don't remember when and where …

Read More
Import SQL file into mysql

I have a database called nitm. I haven't created any tables there. But I have a SQL file which contains all the necessary data for the database. The file is nitm.sql which is in C:\ drive. This file has …

Read More
How to connect from windows command prompt to mysql command line

I'm trying to connect to mysql server command line from my windows prompt I write the next line in cmd but i get an error. cd C:\MYSQL\bin\ And then i execute mysql.exe -u=root -p=admin but …

Read More