正常情况下mysql安装后,使用sudo mysql -u root -p,输入密码时直接回车就可以连接到mysql.
(如果无法连接到mysql,则先在/etc/mysql/mysql.conf.d/mysqld.cnf 的最末尾加上skip-grant-tables)
use mysql;
update user set authentication_string='' where user='root';(将密码置为空)
quit;
如果之前加了skip-grant-tables,删掉/etc/mysql/mysql.conf.d/mysqld.cnf 最末尾的skip-grant-tables,重启mysql服务(sudo service mysql restart)
ALTER USER 'root'@'localhost' IDENTIFIED BY '新密码';
flush privileges;
quit;
如果修改的密码不生效,则试试
#修改加密规则
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
#刷新权限
FLUSH PRIVILEGES;
参考https://blog.csdn.net/qq_43342301/article/details/91288891