Installed XAMPP but can't connect to MYSQL server in cmd

Question

First, MYSQL services is running in XAMPP and, YES, I changed the port since it conflicts with other applications Now, the question is why can't i connect to MYSQL?

Error 2003: Cant connect to MYSQL server on 'localhost'

I also dont have any mysql services installed.

Please help. Thank you for those people who would answer me :)

Try adding PATH variables.

tnchalise
– tnchalise

2015-01-30 05:36:17 +00:00
Commented Jan 30, 2015 at 5:36 — tnchalise
– tnchalise, Commented Jan 30, 2015 at 5:36
yes server is working and its just a localhost

user1888598
– user1888598

2015-01-30 07:03:23 +00:00
Commented Jan 30, 2015 at 7:03 — user1888598
– user1888598, Commented Jan 30, 2015 at 7:03

dbalex · Accepted Answer · 2015-01-30 06:15:03Z

1

First,make sure mysqld is running.

ps -ef |grep mysql

Second,get the socket file in the output of last command:

for example:--socket=/opt/lampp/var/mysql/mysql.sock

Then,try to connect to mysql:

mysql -uroot -p -P<port> -hlocalhost -S /opt/lampp/var/mysql/mysql.sock

answered Jan 30, 2015 at 6:15

dbalex

111 silver badge2 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

kalibbala · Accepted Answer · 2015-01-31 06:50:20Z

1

option 1.

Goto /bin/
Run mysqld (service)
close the cmd prompt
Run mysql.exe (make sure you add the location path to PATH environment Variable)

Option 2. try to follow this thread and see if it can help!! http://forums.devshed.com/mysql-help-4/error-2003-cant-connect-mysql-server-localhost-10061-a-26423.html

edited Jan 31, 2015 at 6:50

answered Jan 31, 2015 at 6:42

kalibbala

5086 silver badges13 bronze badges

Comments

Katiuska Marín · Accepted Answer · 2019-03-20 05:35:48Z

1

Run mysql.exe (make sure you add the location path to PATH environment Variable)

I would to know where is PATH enviroment variable

answered Mar 20, 2019 at 5:35

Katiuska Marín

491 silver badge4 bronze badges

Collectives™ on Stack Overflow

Installed XAMPP but can't connect to MYSQL server in cmd

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related