MySQLdb in Python: "Can't connect to MySQL server on 'localhost'"

Question

I have installed MySQLdb for Python and I am able to import MySQLdb. Now I try to connect to the MySQL Community Server on my local machine, using this code:

db=MySQLdb.connect(
    host="localhost",
    user="br_admin",
    passwd="blabla",
    db="br_brain"
)

This code fails with this error:

Traceback (most recent call last):
  File "<pyshell#22>", line 5, in <module>
  db="brainse_brain"
File "C:\Python27\lib\site-packages\MySQLdb\__init__.py", line 81, in Connect
return Connection(*args, **kwargs)
File "C:\Python27\lib\site-packages\MySQLdb\connections.py", line 187, in __init__
super(Connection, self).__init__(*args, **kwargs2)
OperationalError: (2003, "Can't connect to MySQL server on 'localhost' (10061)")

How do I resolve this error?

Can you connect to the server on localhost outside of python? — Wooble
– Wooble, Commented Jun 20, 2012 at 14:39
NO.The problem is.. Im not able to figure out the host name from my cpanel. In my phpmyadmin in variables i have the hostname as "XXXXXXX"... but when I try its effectless..... — Guru Prakash S
– Guru Prakash S, Commented Jun 21, 2012 at 7:11

Jeff · Accepted Answer · 2014-06-18 20:22:44Z

41

Make sure to provide the proper host and port:

'default': {
    'ENGINE': 'django.db.backends.mysql', 
    'NAME': 'yourdbname',                      
    'USER': 'root',                      
    'PASSWORD': 'your password',         
    'HOST': '127.0.0.1',                 
    'PORT': '3306',                      
},

This is my settings.py file config for my django app.

Same for you please take host "127.0.0.1" and port "3306".

This might solve your problem. And for python idle I've tested like...

>>> import MySQLdb
>>> Con = MySQLdb.Connect(host="127.0.0.1", port=3306, user="yoruname", passwd="yourpwd", db="test")
>>> Cursor = Con.cursor()
>>> sql = "SELECT * FROM test.testing"
>>> Cursor.execute(sql)
2L

edited Jun 18, 2014 at 20:22

Jeff

8409 silver badges18 bronze badges

answered Aug 3, 2012 at 6:32

chirag ghiyad

7001 gold badge8 silver badges15 bronze badges

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

3 Comments

Kaniabi Over a year ago

Actually the problem in my case was that I was using "localhost" instead of "127.0.0.1". Anyway, the simple test you provided was a very welcome help.

Agi Hammerthief Over a year ago

In my case, I accidently supplied the username as the password. Check that all your credentials are correct (instead of assuming they are).

cs_alumnus Over a year ago

Documentation for mysqldb says it defaults to 3306 however at least as of 1.2.3rc1 under python 2.6 I can't connect remotely unless explicitly setting port to 3306.

user2112920 · Accepted Answer · 2013-02-26 20:48:34Z

6

I had the same trouble too, I'm working on a Windows of 64 bits, and the solution just was changing the host variable value. I had set "localhost" when the correct value have to be "127.0.0.1". However, when I'm working on Windows of 32 bits. I can set "localhost" or "127.0.0.1" in the host variable value and no matter, my django's project runs perfectly.

answered Feb 26, 2013 at 20:48

user2112920

611 silver badge1 bronze badge

Comments

dinesh.kumar · Accepted Answer · 2015-09-30 07:28:09Z

3

This will work fine :

    db = MySQLdb.connect(host="127.0.0.1",user="db_username",passwd="db_password",db="db_name")

or

   db=  MySQLdb.connect("127.0.0.1","db_username","db_password","db_name")

edited Sep 30, 2015 at 7:28

answered Sep 30, 2015 at 6:32

dinesh.kumar

1681 silver badge11 bronze badges

Comments

SuperBiasedMan · Accepted Answer · 2015-08-21 11:47:07Z

2

In Windows 32, if you set host as 127.0.01 it gives the down error:

OperationalError: (2005, "Unknown MySQL server host '127.0.01' (0)")

But if you set host as 127.0.0.1 then you get no error.

edited Aug 21, 2015 at 11:47

SuperBiasedMan

10k11 gold badges52 silver badges76 bronze badges

answered Aug 21, 2015 at 11:30

pius

211 bronze badge

1 Comment

Nick Burns Over a year ago

That's because 127.0.01 isn't a valid IP address.

Saher Ahwal · Accepted Answer · 2016-02-24 20:40:24Z

2

If you are using windows you should specify the IP to "127.0.0.1", using "localhost" will give you that error 2003. On Ubuntu I had no problem.

edited Feb 24, 2016 at 20:40

answered Sep 17, 2014 at 10:14

Saher Ahwal

9,26733 gold badges91 silver badges156 bronze badges

2 Comments

NooNa MarJa Over a year ago

couldn't get when i give 127.0.01. But got by giving host as 127.0.0.1

Saher Ahwal Over a year ago

Of course, that's a typo. IP address consists of 4 (1-byte) integers.

Pavel Smirnov · Accepted Answer · 2019-04-06 15:21:14Z

0

1.Go to MySQL workbench
2.On the task bar above, click on server->and then click on Startup/Shutdown
3.On the screen, click on Start the server and you will get logs of server starting and running

edited Apr 6, 2019 at 15:21

Pavel Smirnov

4,8293 gold badges22 silver badges32 bronze badges

answered Apr 6, 2019 at 15:00

Sandeep Amarnath

7,1323 gold badges38 silver badges52 bronze badges

Comments

Suraj Rao · Accepted Answer · 2021-06-21 10:36:44Z

0

 - DATABASES = {
       'default': {
           'ENGINE': 'django.db.backends.mysql',
           'NAME': 'dataflair',
           'USER':'root',
           'PASSWORD':'',
           'HOST':'127.0.0.1',
           'PORT':'3306',
           'OPTIONS':{
       'init_command':"SET sql_mode=STRICT_TRANS_TABLES" }

edited Jun 21, 2021 at 10:36

Suraj Rao

29.7k11 gold badges96 silver badges104 bronze badges

answered Jun 21, 2021 at 10:27

Sanjar

1

1 Comment

Sven Eberth Over a year ago

Welcome to StackOverflow. While this code may answer the question, providing additional context regarding how and/or why it solves the problem would improve the answer's long-term value.

Collectives™ on Stack Overflow

MySQLdb in Python: "Can't connect to MySQL server on 'localhost'"

7 Answers 7

3 Comments

Comments

Comments

1 Comment

2 Comments

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

7 Answers 7

3 Comments

Comments

Comments

1 Comment

2 Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related