mysql服务启动时弹出ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

环境:wsl2,ubuntu20.04 Linux version 5.10.43.3-microsoft-standard-WSL2 (oe-user@oe-host) (x86_64-msft-linux-gcc (GCC) 9.3.0, GNU ld (GNU Binutils) 2.34.0.20200220)

apt安装包:

libdbd-mysql-perl/focal,now 4.050-3 amd64 [installed,automatic]
libmysqlclient21/focal-updates,focal-security,now 8.0.26-0ubuntu0.20.04.2 amd64 [installed,automatic]
mysql-common/focal,now 5.8+1.0.5ubuntu2 all [installed]
mariadb-client-10.3/focal-updates,focal-security,now 1:10.3.29-0ubuntu0.20.04.1 amd64 [installed,automatic]
mariadb-client-core-10.3/focal-updates,focal-security,now 1:10.3.29-0ubuntu0.20.04.1 amd64 [installed,automatic]
mariadb-client/focal-updates,focal-security,now 1:10.3.29-0ubuntu0.20.04.1 all [installed]
mariadb-common/focal-updates,focal-security,now 1:10.3.29-0ubuntu0.20.04.1 all [installed,automatic]
mariadb-server-10.3/focal-updates,focal-security,now 1:10.3.29-0ubuntu0.20.04.1 amd64 [installed,automatic]
mariadb-server-core-10.3/focal-updates,focal-security,now 1:10.3.29-0ubuntu0.20.04.1 amd64 [installed,automatic]
mariadb-server/focal-updates,focal-security,now 1:10.3.29-0ubuntu0.20.04.1 all [installed]

问题描述:之前配置MySQL时不用sudo登录root用户会弹出_ERROR 1698 (28000): Access denied for user 'root'@'localhost'_,然后进数据库改了root密码后就能正常连接了,但是再次启动wsl时使用sudo service mysql start时能启动成功但会弹出_ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)_,同时sudo service mysql stop也显示fail,restart也不行,但是数据库还是能正常连接

img

提示你没有设置密码,设置一下root的密码。