can't login to mysql

[BoratSagdiyev]

I use windows xp cmd line to execute my sql queries. After restarting my computer the other day, I do what I always do to login to mysql:

1.start apache using xampp control panel
2.start mysql using xampp control panel
3.navigate to mysql/bin using windows command line
4.type in "mysql -u root -p" to login

Strangely enough, I cannot login today and get this error:
ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)

Everything was working fine the other day and I haven't changed any settings in the configuration files. Did I forget to do something before logging into mysql? Thank you.

[glitzi85]

Hello,

did you check, whether the MySQL-Server is really running or not? The Labels on the Control Panel are not always as accurate, as they should be. So you may try the Status-Button on the Control Panel, this will tell you how much Threads are running for your MySQL-Server.

glitzi

[BSweet]

After setting up xampp 1.8.1 on windows vista I reset root password. I have been not able to login as follows: C:\xampp\mysql\bin
mysql.exe -h localhost -u root -p
Enter password :************
ERROR 2003 <HY000>: Can't connect to MySQL server on 'localhost; (10061)

I have been searching the internet and have not found an answer. HELP!

[Altrea]

Hi BSweet,

Error 2003 (10061) indicates, that there is no MySQL Server running.
To connect successfully you need to have a mysql server running.

best wishes,
Altrea

[BSweet]

Since XAMPP Console says [mysql] XAMPP MYSQL service is already running on port 3306

can you tell me why I can't login with CMD entry from previous posting?