Ubuntu安装mysql忘记设置密码

配置文件 sudo vim /etc/mysql/debian.cnf

内容如下

# Automatically generated for Debian scripts. DO NOT TOUCH!

[client]

host    = localhost

user    = debian-sys-maint

password = hGu99nJgoWcmCDKT

socket  = /var/run/mysqld/mysqld.sock

[mysql_upgrade]

host    = localhost

user    = debian-sys-maint

password = hGu99nJgoWcmCDKT

socket  = /var/run/mysqld/mysqld.sock

basedir  = /usr

修改 user password这两项

但下次登录需要sudo权限

这个时候执行如下命令

$ sudo mysql -u rootmysql> USE mysql;mysql>UPDATE user SET plugin='mysql_native_password'WHERE user='root';

mysql> FLUSH PRIVILEGES;mysql>exit;

$ sudo service mysql restart$mysql -u root# 初始安装并没有设置密码，所以直接就能登录了