Python, Mysql : localhost connection failed

Question

I want to access my local Mysql database, I am using

import mysql.connector
conn = mysql.connector.connect(user='root',
         password='',
         host='127.0.0.1')

But I have the following error :

mysql.connector.errors.ProgrammingError: 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

Possible duplicate of [Accessing MySQL from Python 3: Access denied for user](http://stackoverflow.com/questions/32852163/accessing-mysql-from-python-3-access-denied-for-user) — vishes_shell, Mar 01 '17 at 13:33
I have tried a space for the password and I have the same problem @Sangharsh — Amy21, Mar 01 '17 at 13:35
thank you @vishes_shell, I have seen this post, it didn't help. — Amy21, Mar 01 '17 at 13:37
`conn = mysql.connector.connect(user='root', password='root');` works. (Assuming root password is `root`) — Sangharsh, Mar 01 '17 at 13:37
In given error, it is mentioned `(using password: NO)`. MySQL by default is not accessible to root without password. — Sangharsh, Mar 01 '17 at 13:38

score 1 · Accepted Answer · answered Mar 01 '17 at 13:39

Use non-empty password. MySQL by default is not accessible to root used without password.

Given error says:

(using password: NO)

Use with password:

import mysql.connector
conn = mysql.connector.connect(user='root',
         password='root',
         host='127.0.0.1')

1 Answers1