Questions tagged [mysql-error-2003]

MySQL Error 2003 (HY000): Can't connect to MySQL server on the specified IP address.

MySQL Error 2003: Can't connect to MySQL server on localhost

41 questions
291
votes
19 answers

Access mysql remote database from command line

I have a server with Rackspace. I want to access the database from my local machine command line. I tried like: mysql -u username -h my.application.com -ppassword But it gives an error: ERROR 2003 (HY000): Can't connect to MySQL server on…
user1986299
  • 2,993
  • 2
  • 13
  • 7
169
votes
4 answers

Can't connect to MySQL server error 111

I installed mysql server on linux box IP = 192.168.1.100 but when i try to connect to this IP it alway error(111). but use localhost and 127.0.0.1 is OK. beer@beer-laptop# ifconfig | grep "inet addr" inet addr:127.0.0.1 Mask:255.0.0.0 …
wearetherock
  • 3,721
  • 8
  • 36
  • 47
166
votes
22 answers

ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (111)

I use the following command: mysql -u root -h 127.0.0.1 -p And the error message is: ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (111) How can I fix it?
Charlie Epps
  • 3,595
  • 9
  • 33
  • 38
46
votes
11 answers

PyMySQL can't connect to MySQL on localhost

I'm trying to connect to MySQL on localhost using PyMySQL: import pymysql conn = pymysql.connect(db='base', user='root', passwd='pwd', host='localhost') but (both on Python 2.7 and Python 3.2) I get the error: socket.error: [Errno 111] Connection…
O'Fermah
  • 565
  • 1
  • 6
  • 9
37
votes
11 answers

ERROR 2003 (HY000): Can't connect to MySQL server (111)

This question is related to the following questions: Can't connect to MySQL server error 111 Trying to connect to remote MySQL host (error 2003) I am configuring a new MySQL (5.1) server on my local machine. I need to provide remote access to the…
Nick Ruiz
  • 1,405
  • 4
  • 18
  • 28
28
votes
5 answers

Trying to connect to remote MySQL host (error 2003)

I have a MySQL instance running on a Debian server and I can connect to it locally with no problems. However, I am unable to connect to it remotely. When I try this from my command line I get the following error: ERROR 2003 (HY000): Can't connect…
hellsgate
  • 5,905
  • 5
  • 32
  • 47
25
votes
19 answers

How to start MySQL server on windows xp

Whenever I try to start MySQL by typing > mysql -u root I get the error ERROR 2003(HY000): Can't connect to MySQL server on 'localhost' (10061) How can I solve the problem above? I just downloaded MySQL and unzipped it in the E: drive. I have not…
Dusk
  • 2,191
  • 6
  • 38
  • 57
9
votes
5 answers

MYSQL - Cant connect to MYSQL server on 'localhost' (10061)

Ive install wamp server on my PC(it has no internet or intranet connection, Windows XP -OS). But when I access MYSQL this error popup. Can you give any idea on how can i resolve this error. thank you very much. Cant connect to MYSQL server on…
nero
8
votes
4 answers

Problems in connecting to mysql server: ERROR 2003 (HY000)

Server ip: 172.16.1.169 mysql user name: root passwd: xxxxxxxxxx database name: example I'm trying to access a database from a client (ip 172.16.0.114). Both the server and client are running the Fedora distribution of Linux. What settings need…
Jagan
  • 4,649
  • 19
  • 60
  • 70
6
votes
3 answers

Can't get mysqldump to connect to local mysql instance (error 2003 / 10061)

I've got mysql 5.1 on a windows xp machine. It's listening on port 3308. I'm trying to use mysqldump: > mysqldump -u root -pmypassword dbname > out.sql Getting an error: mysqldump: Got error: 2003: Can't connect to MySQL server on 'localhost'…
user291701
  • 38,411
  • 72
  • 187
  • 285
5
votes
5 answers

Can't connect to MySQL server on localhost (10061) on window 7

I am having window 7 as a operating system in the production machine where i am trying to use MySQL server 5.0 as a database. But i am unable to configure MySQL on my production machine. Following is the error i am receiving. The security setting…
R. Rahul
  • 1,166
  • 3
  • 16
  • 40
5
votes
4 answers

Weird MySQL Python mod_wsgi Can't connect to MySQL server on 'localhost' (49) problem

There have been similar questions on StackOverflow about this, but I haven't found quite the same situation. This is on a OS X Leopard machine using MySQL Some starting information: MySQL Server version 5.1.30 Apache/2.2.13 (Unix) Python…
user218112
5
votes
6 answers

how to understand "can't connect" mysql error messages?

I have the following error message: SQLSTATE[HY000] [2003] Can't connect to MySQL server on '192.168.50.45' (4) How would I parse this (I have HY000, I have 2003 and I have the (4).
Itay Moav -Malimovka
  • 52,579
  • 61
  • 190
  • 278
4
votes
5 answers

XAMPP on windows 7 not working properly

I just installed XAMPP lite on Windows 7. I have two drives - C: for the OS and regular files, and an external drive E:. I installed XAMPP lite on E: (on the root), and its been giving me problems. Apache works well enough, but MySQL doesn't work.…
404Error
  • 53
  • 1
  • 1
  • 3
2
votes
1 answer

#2003 - Can't connect to MySQL server on 'localhost' (10061)

I just installed wamp.. I have mysql 5.1.33... On the icon in the task bar it says that the server is online, but when I go to open PHPMyAdmin, it gives me error 2003. Please help
Jonathan Garrido
1
2 3