当前位置：Gxlcms >
数据库问题 >
MySQL问题:Access denied for user 'mysql'@'localhost'
MySQL问题:Access denied for user 'mysql'@'localhost'
时间：2021-07-01 10:21:17
帮助过：22人阅读
> update mysql.user
set authentication_string=PASSWORD(
‘mysql‘), plugin=
‘mysql_native_password‘ where user=
‘root‘;
Query OK, 1 row affected,
1 warning (
0.04 sec)
Rows matched: 1 Changed:
1 Warnings:
1
mysql>
flush privileges;
Query OK, 0 rows affected (
0.00 sec)
mysql>
exit
Bye
deep@deep-PC:~$ sudo service mysql restart
deep@deep-PC:~$ mysql -uroot -p
MySQL问题:Access denied for user 'mysql'@'localhost'
标签：div localhost bsp host ring mys tar password user
