can't login to mysql

Alles, was MariaDB und MySQL betrifft, kann hier besprochen werden.

can't login to mysql

Postby BoratSagdiyev » 07. January 2008 01:40

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.
BoratSagdiyev
 
Posts: 14
Joined: 28. November 2007 04:54

Postby glitzi85 » 22. January 2008 01:34

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
User avatar
glitzi85
 
Posts: 1920
Joined: 05. March 2004 23:26
Location: Dahoim

Re: can't login to mysql

Postby BSweet » 18. November 2012 04:17

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!
BSweet
 
Posts: 2
Joined: 18. November 2012 04:03
Operating System: Windows Vista

Re: can't login to mysql

Postby Altrea » 18. November 2012 10:16

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
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 8293
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: can't login to mysql

Postby BSweet » 20. November 2012 02:04

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?
BSweet
 
Posts: 2
Joined: 18. November 2012 04:03
Operating System: Windows Vista


Return to MariaDB - MySQL

Who is online

Users browsing this forum: No registered users and 2 guests