MYSQL.CONNECTOR ERROR

[DB1]

I am trying to connect MySQL(8.0.25) and python(3.9.6) using mysql.connector but getting error.

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

Code:

1 2	import mysql.connector as sql s=sql.connect(host='localhost' ,user='root', password='<correct password>',database='empl')

The password I entered is the one I use to successfully login to MySQL 8.0 Command line client.
Same code is working for pymysql.connect without any error.
I checked out the Host and User Name by logging in to MYSQL 8.0 Command Line client with my password and typing:

1	mysql>Select current_user;

And got the Output:

Output:
+----------------+
| current_user   |
+----------------+
| root@localhost |
+----------------+

Thanks in advance.
Kindly help me out as I tried everything but couldn't solve it.
Looking forward for a reply.

Larz60+ write Jul-11-2021, 06:13 PM:
Please post all code, output and errors (it it's entirety) between their respective tags. Refer to BBCode help topic on how to post. Use the "Preview Post" button to make sure the code is presented as you expect before hitting the "Post Reply/Thread" button.
Please refrain from using images for code.

[jefsummers]

Suspect from the documents that you must specify a database. See the MySQL connector for Python documents HERE

[DB1]

Suspect from the documents that you must specify a database. See the MySQL connector for Python documents HERE

I even tried that out, but, unfortunately, that doesn't make any difference.

Eagerly waiting for someone to help me out.

[menator01]

You could try pymysql. MYSQL connector seems to not play well with python 3

[Pedroski55]

I second menator01's answer.

I use pymsql to collect data from my webpage database. Works amazingly fast, just 1 or 2 seconds to collect data from 168 students and write it to a results Excel file!! I am always flabbergasted! Used to take me a long time copying and pasting and sorting stuff!

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25

import pymysql import openpyxl import os   def mysqlRemote(clas, weeknr):     # To connect to remote MySQL database     conn = pymysql.connect(         host='123.456.789.123',         user='allstudents',          password = 'blurb',         db='mydb',         )             cur = conn.cursor()           # Select query     cur.execute(f"SELECT studentnr, score FROM allstudentsAnswers{clas} WHERE weeknr = '{weeknr}'")     output = cur.fetchall()             #for i in output:         #print(i)             # To close the connection     conn.close()     return output

[DB1]

You could try pymysql. MYSQL connector seems to not play well with python 3

pymysql is working very well for me too. But, as per my school course, I am bound to use mysql.connector.

[DB1]

I second menator01's answer.

I use pymsql to collect data from my webpage database. Works amazingly fast, just 1 or 2 seconds to collect data from 168 students and write it to a results Excel file!! I am always flabbergasted! Used to take me a long time copying and pasting and sorting stuff!

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25

import pymysql import openpyxl import os   def mysqlRemote(clas, weeknr):     # To connect to remote MySQL database     conn = pymysql.connect(         host='123.456.789.123',         user='allstudents',          password = 'blurb',         db='mydb',         )             cur = conn.cursor()           # Select query     cur.execute(f"SELECT studentnr, score FROM allstudentsAnswers{clas} WHERE weeknr = '{weeknr}'")     output = cur.fetchall()             #for i in output:         #print(i)             # To close the connection     conn.close()     return output

pymysql is working very well for me too. But, as per my school course, I am bound to use mysql.connector.

[DB1]

I second menator01's answer.

I use pymsql to collect data from my webpage database. Works amazingly fast, just 1 or 2 seconds to collect data from 168 students and write it to a results Excel file!! I am always flabbergasted! Used to take me a long time copying and pasting and sorting stuff!

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25

import pymysql import openpyxl import os   def mysqlRemote(clas, weeknr):     # To connect to remote MySQL database     conn = pymysql.connect(         host='123.456.789.123',         user='allstudents',          password = 'blurb',         db='mydb',         )             cur = conn.cursor()           # Select query     cur.execute(f"SELECT studentnr, score FROM allstudentsAnswers{clas} WHERE weeknr = '{weeknr}'")     output = cur.fetchall()             #for i in output:         #print(i)             # To close the connection     conn.close()     return output

pymysql is working very well for me too. But, as per my school course, I am bound to use mysql.connector.

Looking forward for a reply to help me out.

[DB1]

Someone kindly help me out!