高版本的mysql修改密码方式有所改变,不适用非5.7的版本。
终端输入:sudo cat /etc/mysql/debian.cnf
[client]
host = localhost
user = debian-sys-maint
password = PGBiNPneSGXRlayQ
socket = /var/run/mysqld/mysqld.sock
[mysql_upgrade]
host = localhost
user = debian-sys-maint
password = PGBiNPneSGXRlayQ
socket = /var/run/mysqld/mysqld.sock
终端输入:mysql -u debian-sys-maint -pPGBiNPneSGXRlayQ"
mysql>
在mysql客户端中输入依次输入以下内容:
mysql> show databases;
mysql> use mysql;
mysql> update user set authentication_string=PASSWORD("root") where user="root";
其中PASSWORD后面的root可以为其他自定义的密码,
mysql> update user set plugin="mysql_native_password";
mysql> flush privileges;
mysql> quit;
其中PASSWORD后面的root可以为其他自定义的密码,
在终端中输入 sudo /etc/init.d/mysql restart; 命令,重启mysql服务
使用新密码登录mysql:mysql -u root -p
安装mysql8.0
apt update
sudo apt install mysql-server
use mysql;
alter user 'root'@'localhost' identified with mysql_native_password by 'mysql';
flush privileges;