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 — vishes_shell
– vishes_shell, Commented Mar 1, 2017 at 13:33
I have tried a space for the password and I have the same problem @Sangharsh — Amy21
– Amy21, Commented Mar 1, 2017 at 13:35
thank you @vishes_shell, I have seen this post, it didn't help. — Amy21
– Amy21, Commented Mar 1, 2017 at 13:37
conn = mysql.connector.connect(user='root', password='root'); works. (Assuming root password is root) — Sangharsh
– Sangharsh, Commented Mar 1, 2017 at 13:37

Sangharsh · Accepted Answer · 2017-03-01 13:39:40Z

1

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')

answered Mar 1, 2017 at 13:39

Sangharsh

3,0292 gold badges17 silver badges28 bronze badges

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

1 Answer 1