Python连接MySQL数据库（mys

数据运维 2023-08-12 向阳逐梦 手机阅读

Traceback (most recent call last):

  File "test.py", line 7, in

    database='test')

  File "/usr/lib/python2.7/dist-packages/mysql/connector/__init__.py", line 162, in connect

    return MySQLConnection(*args, **kwargs)

  File "/usr/lib/python2.7/dist-packages/mysql/connector/connection.py", line 129, in __init__

    self.connect(**kwargs)

  File "/usr/lib/python2.7/dist-packages/mysql/connector/connection.py", line 454, in connect

    self._open_connection()

  File "/usr/lib/python2.7/dist-packages/mysql/connector/connection.py", line 421, in _open_connection

    self._ssl)

  File "/usr/lib/python2.7/dist-packages/mysql/connector/connection.py", line 204, in _do_auth

    self._auth_switch_request(username, password)

  File "/usr/lib/python2.7/dist-packages/mysql/connector/connection.py", line 240, in _auth_switch_request

    raise errors.get_exception(packet)

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