数据库重置密码

[root@linux ~]# systemctl stop mariadb

[root@linux ~]# mysqld_safe --skip-grant-tables &

[1] 26870

[root@linux ~]# 190305 14:23:41 mysqld_safe Logging to '/var/log/mariadb/mariadb.log'.

190305 14:23:41 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql

 

[root@linux ~]# mysql

Welcome to the MariaDB monitor.  Commands end with ; or \g.

Your MariaDB connection id is 11

Server version: 5.5.60-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)]> use mysql;

Reading table information for completion of table and column names

You can turn off this feature to get a quicker startup with -A

 

Database changed

MariaDB [mysql]> UPDATE user SET password=password('newpassword') WHERE user='root';

Query OK, 3 rows affected (0.00 sec)

Rows matched: 3  Changed: 3  Warnings: 0

 

MariaDB [mysql]> flush privileges;

Query OK, 0 rows affected (0.00 sec)

 

MariaDB [mysql]> exit;

Bye

[root@linux ~]# kill -9 26870

[root@linux ~]# systemctl start mariadb

[1]+  已杀死               mysqld_safe --skip-grant-tables

[root@linux ~]# mysql

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

[root@linux ~]# mysql -uroot -pnewpassword

Welcome to the MariaDB monitor.  Commands end with ; or \g.

Your MariaDB connection id is 16

Server version: 5.5.60-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)]>