mariadb-修改初始密码

1. 跳过密码认证过程
   在my.conf 中添加

[mysqld]
skip-grant-tables

2. 进到数据库进行操作

# mysql
Welcome to the MariaDB monitor.  Commands end with ;
Your MariaDB connection id is 59
Server version: 10.3.18-MariaDB MariaDB Server

Copyright (c) 2000, 2018, Oracle, MariaDB Corporatio

Type 'help;' or '\h' for help. Type '\c' to clear th

3. 选择数据库

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

4. 用户root添加密码

MariaDB [mysql]> update user set password=password("123") where user="root";
Query OK, 0 rows affected (0.005 sec)
Rows matched: 3  Changed: 0  Warnings: 0

5. 赋予权限

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

6. 退出后重新登陆

// 无密码登陆失败
# mysql 
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
# mysql -u root -p //成功