l连接mysql数据库时报错(1045 Access denied for user 'root'@'127.0.0.1 (using password: YES))

具体内容：Traceback (most recent call last):

File "E:/python_events/ch01/mysqldb_test.py", line 13, in <module>

port=3306)

File "E:\Python_install\lib\site-packages\pymysql\__init__.py", line 90, in Connect

return Connection(*args, **kwargs)

File "E:\Python_install\lib\site-packages\pymysql\connections.py", line 699, in __init__

self.connect()

File "E:\Python_install\lib\site-packages\pymysql\connections.py", line 928, in connect

self._request_authentication()

File "E:\Python_install\lib\site-packages\pymysql\connections.py", line 1148, in _request_authentication

auth_packet = self._read_packet()

File "E:\Python_install\lib\site-packages\pymysql\connections.py", line 1010, in _read_packet

packet.check_error()

File "E:\Python_install\lib\site-packages\pymysql\connections.py", line 393, in check_error

err.raise_mysql_exception(self._data)

File "E:\Python_install\lib\site-packages\pymysql\err.py", line 107, in raise_mysql_exception

raise errorclass(errno, errval)

pymysql.err.OperationalError: (1045, "Access denied for user 'root'@'127.0.0.1' (using password: YES)")

解决方法：

1.mysql -uroot -p 登录

2. use mysql;

3.select Host,User,Password from user; 查看root下的password是否一致

4.如果不一致，更改密码update user set password=password('填写自己的密码') where user='root'

5.flush privileges;

6.exit

7.重启mysql service mysqld restart