Can't connect to mysql server on windows 10

Asked Sep 11 '18 at 07:34

Active Sep 11 '18 at 11:52

Viewed 1,236 times

I am trying to connect the MySQL server (mysql-5.7.23) from command prompt using the command mysql -u root it throws an error ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061). I am using Windows 10.

I have followed following steps :

Unzip the mysql-5.7.23 file and put on C drive.
Add the data folder in the installation directory and also add the my.ini
Went to the bin folder in command prompt and executed mysqld --initialize-insecure, it generated some file in the data folder.
Then I added the mysql path environment variable.
After that I started MySQL service. It is running properly.
Again in the command prompt, I have executedmysqld --install, it shows service already exists.
But when I tried to connect to the server, it throws an error, ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)

I have tried all solutions from ERROR 2003 (HY000): Can't connect to MySQL server on localhost (10061) , but still it is not working.

Am I missing something?

Edit : One more observation, when I execute mysqld, the cursor in the command prompt return to again current directory, which I think is not expected behavior.

edited Sep 11 '18 at 11:52

asked Sep 11 '18 at 07:34

Suhas Bhattu

1

Check the Task Manager, is the mysqld.exe is running on the Process tab? – Adlan Arif Zakaria Sep 11 '18 at 07:38
Are you running the command prompt as admin? – Siddhant Sahni Sep 11 '18 at 07:38
firewall? (check Settings > Update & Security > Windows Security > Firewall & network protection) – Dewfy Sep 11 '18 at 07:43
@AdlanArifZakaria yes, the mysqld.exe is running – Suhas Bhattu Sep 11 '18 at 08:59
@SiddhantSahni yes, I run the cmd as admin, but still problem is there – Suhas Bhattu Sep 11 '18 at 08:59
Try kill that process first, then run `mysqld --install` – Adlan Arif Zakaria Sep 11 '18 at 09:12

Can't connect to mysql server on windows 10

0 Answers0