尝试将Python连接到mySQL数据库时出现“Access dedied错误”

Question

我试图将python连接到mysql数据库，但它抛出Access denied for user 'root'@'localhost'。我正在使用linux操作系统

这是我的密码：

import mysql.connector as sa
db = sa.connect(host="localhost",user="root",password="sandy123",database="school")
print(db)

这就是错误所在

Traceback (most recent call last): File "/home/sandytom/.local/lib/python3.6/site-packages/mysql/connector/connection_cext.py", line 216, in _open_connection self._cmysql.connect(**cnx_kwargs) _mysql_connector.MySQLInterfaceError: Access denied for user 'root'@'localhost'

During handling of the above exception, another exception occurred:

Traceback (most recent call last): File "swip.py", line 2, in db = fuck.connect(host="localhost",user="root",password="sandy123") File "/home/sandytom/.local/lib/python3.6/site-packages/mysql/connector/init.py", line 264, in connect return CMySQLConnection(*args, **kwargs) File "/home/sandytom/.local/lib/python3.6/site-packages/mysql/connector/connection_cext.py", line 80, in init self.connect(**kwargs) File "/home/sandytom/.local/lib/python3.6/site-packages/mysql/connector/abstracts.py", line 966, in connect self._open_connection() File "/home/sandytom/.local/lib/python3.6/site-packages/mysql/connector/connection_cext.py", line 219, in _open_connection sqlstate=exc.sqlstate) mysql.connector.errors.ProgrammingError: 1698 (28000): Access denied for user 'root'@'localhost' sandytom@sandytom-Lenovo-ideapad-320-15ISK:~/Desktop/ruber$ python3 swip.py Traceback (most recent call last): File "/home/sandytom/.local/lib/python3.6/site-packages/mysql/connector/connection_cext.py", line 216, in _open_connection self._cmysql.connect(**cnx_kwargs) _mysql_connector.MySQLInterfaceError: Access denied for user 'root'@'localhost'

During handling of the above exception, another exception occurred:

Traceback (most recent call last): File "swip.py", line 2, in db = fuck.connect(host="localhost",user="root",password="sandy123",database="school") File "/home/sandytom/.local/lib/python3.6/site-packages/mysql/connector/init.py", line 264, in connect return CMySQLConnection(*args, **kwargs) File "/home/sandytom/.local/lib/python3.6/site-packages/mysql/connector/connection_cext.py", line 80, in init self.connect(**kwargs) File "/home/sandytom/.local/lib/python3.6/site-packages/mysql/connector/abstracts.py", line 966, in connect self._open_connection() File "/home/sandytom/.local/lib/python3.6/site-packages/mysql/connector/connection_cext.py", line 219, in _open_connection sqlstate=exc.sqlstate) mysql.connector.errors.ProgrammingError: 1698 (28000): Access denied for user 'root'@'localhost'

Answer 1

在这种情况下，仔细阅读错误消息会有所帮助。以下是信息的重要部分：

Access denied for user 'root'@'localhost'

看起来您给MySQL的用户名/密码组合无效root可能是正确的，因此您应该检查您的密码

一个好方法是尝试使用MySQL客户端程序登录，比如MySQL客户端程序或者HeidiSQL。这样，您可以确保在运行python程序之前拥有正确的密码