1、修改密码
方法一
[root@host1 ~]# mysqladmin -uroot -p password
Enter password:
New password:
Confirm new password:
方法二
mysql> alter user root@localhost identified by 'MySQL@123';
Query OK, 0 rows affected (0.00 sec)
方法三
通过修改mysql数据库里面的user表中的authentication_string
mysql> select user,host,authentication_string from mysql.user;
mysql> update mysql.user set authentication_string=password('MySQL@123') where user='root' and host='localhost';
mysql> FLUSH PRIVILEGES;
2、root密码遗忘
①关闭数据库
systemctl stop mysqld
②修改主配置文件(/etc/my.cnf) 添加: skip-grant-tables 启动数据库
vim /etc/my.cnf
③重启数据库并登录
此时不需密码便可登录数据库,接着进入数据库之后修改密码
mysql> alter user root@localhost identified by 'MySQL@123';