# 修改root用户密码
update mysql.user set Password=password('123') where Host='localhost' and User='root';
# 刷新权限
flush privileges;
# 刷新完权限退出数据库
MariaDB [(none)]>exit
Bye
# 输入密码登陆至mysql数据库[root@ localhost ~]# mysql -uroot -p123
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 8
Server version: 5.5.64-MariaDB MariaDB Server
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h'for help. Type '\c' to clear the current input statement.
MariaDB [(none)]>
第二种修改方式
set password for root@'localhost'=password('123456');
MariaDB [(none)]>set password for root@'localhost'=password('123456');
Query OK, 0 rows affected (0.00 sec)# 无需刷新权限
MariaDB [(none)]>exit
Bye
[root@ localhost ~]# mysql -uroot -p123456
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 9
Server version: 5.5.64-MariaDB MariaDB Server
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h'for help. Type '\c' to clear the current input statement.
set password for root@'localhost'= password('kdakfkakjltfkasoitioa');
systemctl stop mariadb
mysqld_safe --skip-grant-tables
update mysql.user set Password=password('123') where Host='localhost' and User='root';
flush privileges;
找到它的进程强制杀死
现在又可以正常输入密码登陆至数据库了
[root@ localhost ~]# mysql -uroot -p123
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 10
Server version: 5.5.64-MariaDB MariaDB Server
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h'for help. Type '\c' to clear the current input statement.
MariaDB [(none)]>