mysql doesn't connect to the database python

Question

So when I run this python script on my Ubuntu 20.04 machine:

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

it gives me the following error : mysql.connector.errors.ProgrammingError: 1045 (28000): Access denied for user 'test'@'localhost' (using password: NO) Any ideas ?

Obviously the connection states user: `test` where you show config with user: `root` , so somewhere there's something configured wrong. — Ron, Sep 10 '20 at 12:16
Did you do any research, or red the DOCs ? [this answer](https://stackoverflow.com/questions/372885/how-do-i-connect-to-a-mysql-database-in-python?rq=1) can help — Ron, Sep 10 '20 at 12:19

score 0 · Answer 1 · answered Sep 10 '20 at 12:57

0

check your user details using mysql.user table. You probably have an anonymous user ''@'localhost' or ''@'127.0.0.1'. so drop this user/create again or create new user.

answered Sep 10 '20 at 12:57

Hewarathna Ashen Iranga

103
3
8

score 0 · Answer 2 · edited Sep 11 '20 at 07:13

0

I fixed my problem(sort of) by uninstalling mysql server and installing mariadb instead. although this is probably just avoiding the problem and not fixing it. It worked for me.

edited Sep 11 '20 at 07:13

Hamid Naghipour

3,465
2
26
55

answered Sep 10 '20 at 16:59

user13930404

11
1
3

mysql doesn't connect to the database python

2 Answers2