mariadb10 忘记密码

skip-grant-tables
启动，登录更改密码，记得先要privileges

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]> SET PASSWORD FOR 'root'@localhost = PASSWORD("");
ERROR 1290 (HY000): The MariaDB server is running with the --skip-grant-tables option so it cannot execute this statement
MariaDB [mysql]> flush privileges;
Query OK, 0 rows affected (0.023 sec)

MariaDB [mysql]> SET PASSWORD FOR 'root'@localhost = PASSWORD("root1234");
Query OK, 0 rows affected (0.000 sec)

MariaDB [mysql]> flush privileges;
Query OK, 0 rows affected (0.001 sec)

MariaDB [mysql]> quit