Site icon 时鹏亮的Blog

MySQL 错误 Access denied for user ‘debian-sys-maint’@’localhost’错误解决办法

请知悉:本文最近一次更新为 9年 前,文中内容可能已经过时。
cat /etc/mysql/debian.cnf
[client]
host = localhost
user = debian-sys-maint
password = 4AiDYEIp8AJIwEe1
socket = /var/run/mysqld/mysqld.sock
[mysql_upgrade]
user = debian-sys-maint
password = 4AiDYEIp8AJIwEe1
socket = /var/run/mysqld/mysqld.sock
basedir = /u

得到密码
进入mysql命令行

mysql> update mysql.user set Password = password("4AiDYEIp8AJIwEe1") where User ="debian-sys-maint";
mysql>flush privileges;
mysql>quit
/etc/init.d/mysql restart

即可解决.

方法来自:http://www.huzs.net/ p=901


如您从本文得到了有价值的信息或帮助,请考虑扫描文末二维码捐赠和鼓励。

尊重他人劳动成果。转载请务必附上原文链接,我将感激不尽。


与《MySQL 错误 Access denied for user ‘debian-sys-maint’@’localhost’错误解决办法》相关的博文:

Exit mobile version