1、使用set password命令
mysql -uroot
mysql> use mysql
mysql> set password for 'root'@'localhost' = PASSWORD('newpass');
mysql> flush privileges;
mysql> select user,host,password from user;
mysql> exit
2、使用update user表
mysql -uroot
mysql> use mysql
mysql> update user set password = PASSWORD('newpass') where user = 'root';
mysql> flush privileges;
mysql> select user,host,password from user;
mysql> exit;
3、使用mysqladmin命令
配置新密码:
# mysqladmin -uroot password "newpass"
重置密码:
# mysqladmin -uroot password oldpass "newpass"
4、忘记root密码时
在配置文件/etc/my.cnf的[mysqld]选项下添加skip-grant-tables
重启数据库服务:
# systemct restart mariadb
重置密码:
mysql -uroot
mysql> update user set password=password('newpass') where user='root' and host='localhost';
mysql> flush privileges;
mysql> select user,host,password from user;
mysql> exit;