该楼层疑似违规已被系统折叠 隐藏此楼查看此楼
MySQL 5.7不再弹出root密码设置
sudo vi /etc/mysql/debian.cnf
显示:
# Automatically generated for Debian scripts. DO NOT TOUCH!
[client]
host = localhost
user = debian-sys-maint
password = fPw**********22
socket = /var/run/mysqld/mysqld.sock
[mysql_upgrade]
host = localhost
user = debian-sys-maint
password =fPw**********22
socket = /var/run/mysqld/mysqld.sock
找到了,用户名:debian-sys-maint,密码:fPw**********22(这是随机生成的)
退出来,Esc键,输入“:q!”
mysql -u debian-sys-maint -p
Enter password:输入刚才找到的密码
接下来,设置root用户密码(假设为123456)
mysql> update mysql.user set authentication_string=PASSWORD(“123456″) where User=’root’;
更改root密码,然后出现
Query OK, 1 row affected, 1