ubuntu下mysql-server-8.x设置密码
mysql-server-8.x设置密码的方式和5.7不同,在ubuntu下比如要将密码改为123456
,在终端执行以下操作即可:
sudo mysql
flush privileges;
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';
flush privileges;
exit
界面效果
test@test:~$ sudo mysql
mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)
mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';
Query OK, 0 rows affected (0.01 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)
mysql> exit
Bye
test@test:~$
然后再次登录就可以正常用了
test@test:~$ mysql -uroot -p123456
mysql>