Ubuntu安装mysql忘记设置密码
2018-10-25 本文已影响0人
handle_d717
配置文件 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# 初始安装并没有设置密码，所以直接就能登录了
