MYSQL 修改修改数据库密码时 ERROR 1045 (28000)错误解决方法

xiaoxiao2021-02-28  22

详情错误:ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

通过 desc user;命令查看有哪些表

mysql> update user set authentication_string=password('123456') where user='root';

Query OK, 1 row affected, 1 warning (0.00 sec)

Rows matched: 1  Changed: 1  Warnings: 1

转载请注明原文地址: https://www.6miu.com/read-2628069.html

最新回复(0)