Read table from MySQL - Python

Question

I have MySQL ( Database: items, Table: issuelist )

I want to read and print out by python... but when I run code as below, it show error.

import mysql.connector
#from mysql.connector import Error

mydb = mysql.connector.connect(
host="localhost",
#user="yourusername",
#passwd="yourpassword",
database="items"
)

mycursor = mydb.cursor()
sql_statement = "SELECT * FROM issuelist"

mycursor.execute(sql_statement)
myresult = mycursor.fetchall()

for x in myresult:
print(x)

Traceback (most recent call last): File "C:\Users\Administrator\Desktop\Chatbot - ReadData\ExcelMySQL.py", line 8, in database="items" File "C:\Users\Administrator\AppData\Local\Programs\Python\Python37\lib\site-packages\mysql\connector__init__.py", line 219, in connect return MySQLConnection(*args, **kwargs) File "C:\Users\Administrator\AppData\Local\Programs\Python\Python37\lib\site-packages\mysql\connector\connection.py", line 104, in init self.connect(**kwargs) File "C:\Users\Administrator\AppData\Local\Programs\Python\Python37\lib\site-packages\mysql\connector\abstracts.py", line 960, in connect self._open_connection() File "C:\Users\Administrator\AppData\Local\Programs\Python\Python37\lib\site-packages\mysql\connector\connection.py", line 292, in _open_connection self._ssl, self._conn_attrs) File "C:\Users\Administrator\AppData\Local\Programs\Python\Python37\lib\site-packages\mysql\connector\connection.py", line 212, in _do_auth self._auth_switch_request(username, password) File "C:\Users\Administrator\AppData\Local\Programs\Python\Python37\lib\site-packages\mysql\connector\connection.py", line 256, in _auth_switch_request raise errors.get_exception(packet) mysql.connector.errors.ProgrammingError: 1045 (28000): Access denied for user ''@'localhost' (using password: NO)

How to do resolve ?

Thanks you so much!

Does this answer your question? MySQL ERROR 1045 (28000): Access denied for user 'bill'@'localhost' (using password: YES) — Jens
– Jens, Commented Mar 6, 2020 at 8:09

Loïc · Accepted Answer · 2020-03-06 08:05:11Z

1

The error message is quite explanatory :

Access denied for user ''@'localhost' (using password: NO)

You can't just connect to mysql with no account...

answered Mar 6, 2020 at 8:05

Loïc

12k2 gold badges35 silver badges52 bronze badges

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

1 Comment

HaDoan Over a year ago

Thanks you so much!

alexzhu · Accepted Answer · 2020-03-06 08:10:49Z

0

The error msg clearly shows the mistake -- The connect info is not correct. That is ,in your code, make sure the info of the host,user,passwd and database are all correct?

answered Mar 6, 2020 at 8:10

alexzhu

111 bronze badge

Collectives™ on Stack Overflow

Read table from MySQL - Python

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related