Python script unable to connect to MySQL db with no password

Question

I am having a weird issue with my python script. My script has to connect to MySQL DB. This is the code:

try:
   conn = MySQLdb.connect( user='root', host = 'localhost')
   cursor = conn.cursor()
   databases = cursor.fetchall()
   cursor.close()
except Exception as e:
   print e

when I run this script I have and error like:

(1045, "Access denied for user 'root'@'localhost' (using password: NO")

in the other hand, I can connect to MySQL just by entering MySQL (without password).

Why am I having this error with my python script when there is no password to root user?

Himanshu dua · Accepted Answer · 2017-08-17 07:58:17Z

4

Provide empty password try this

conn = MySQLdb.connect( user='root', host = 'localhost', passwd='')

edited Aug 17, 2017 at 7:58

Himanshu dua

2,5141 gold badge22 silver badges28 bronze badges

answered Aug 17, 2017 at 7:01

N1gthm4r3

7931 gold badge11 silver badges24 bronze badges

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

Comments

Dinidu Hewage · Accepted Answer · 2017-08-17 08:25:10Z

2

This should be the syntax. You should have the MySql connector for Python

import mysql.connector

cnx = mysql.connector.connect(user='root', password='',
                              host='127.0.0.1',
                              database='database_name')
cnx.close()

edited Aug 17, 2017 at 8:25

answered Aug 17, 2017 at 6:58

Dinidu Hewage

2,1997 gold badges42 silver badges51 bronze badges

Comments

Andy McRae · Accepted Answer · 2017-08-17 07:04:38Z

0

try this (inside the bloc try except)

import mysql.connector
conn = mysql.connector.connect(user='root', password='',host='localhost',                          
                              database='your_database_name')
conn.close()

answered Aug 17, 2017 at 7:04

Andy McRae

75212 silver badges21 bronze badges

Collectives™ on Stack Overflow

Python script unable to connect to MySQL db with no password

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related