新版 mariadb 无法通过修改 password 字段完成密码重设
新的字段已被改为 authentication_string
新的命令为
MariaDB [(none)]> UPDATE mysql.user SET authentication_string=PASSWORD('redhat') WHERE User='root';
Query OK, 1 row affected (0.000 sec)
Rows matched: 1 Changed: 1 Warnings: 0
MariaDB [(none)]>
MariaDB [(none)]> flush privileges;
Query OK, 0 rows affected (0.000 sec)
MariaDB [(none)]> Bye