Linux MariaDB 遗忘密码后重置密码

• 1
• 2
• 3
• 4
• 5
• 6

• 1
• 2
• 3
• 4
• 5
• 6

重启相关服务

该示例使用的是 MariaDB，重启该服务并查看是否启动成功：

<code class="hljs ruby has-numbering">[root<span class="hljs-variable">@node9 ~]<span class="hljs-comment"># systemctl restart mariadb
[root<span class="hljs-variable">@node9 ~]<span class="hljs-comment"># systemctl status mariadb</span></span></span></span></code>

• 1
• 2

• 1
• 2

登陆数据库修改密码

<code class="hljs ruby has-numbering">[root<span class="hljs-variable">@node9 ~]<span class="hljs-comment"># mysql -uroot -p
<span class="hljs-constant">MariaDB [mysql]> <span class="hljs-constant">UPDATE user <span class="hljs-constant">SET <span class="hljs-constant">Password = password(<span class="hljs-string">‘48eb1c1c770d4bbc‘) <span class="hljs-constant">WHERE <span class="hljs-constant">User = <span class="hljs-string">‘root‘ ;
<span class="hljs-constant">Query <span class="hljs-constant">OK, <span class="hljs-number">4 rows affected (<span class="hljs-number">0.<span class="hljs-number">00 sec)
<span class="hljs-constant">Rows <span class="hljs-symbol">matched: <span class="hljs-number">4  <span class="hljs-constant">Changed<span class="hljs-symbol">: <span class="hljs-number">4  <span class="hljs-constant">Warnings<span class="hljs-symbol">: <span class="hljs-number">0</span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></code>

• 1
• 2
• 3
• 4

• 1
• 2
• 3
• 4

这边需要注意 password 必须需要写进来，否则修改不完全，报错信息如下：

<code class="hljs r has-numbering">[root@node9 ~]<span class="hljs-comment"># mysql -uroot -p
MariaDB [mysql]> UPDATE user SET Password = <span class="hljs-string">‘48eb1c1c770d4bbc‘ WHERE User = <span class="hljs-string">‘root‘ ;
Query OK, <span class="hljs-number">4 rows affected (<span class="hljs-number">0.00 sec)
Rows matched: <span class="hljs-number">4  Changed: <span class="hljs-number">4  Warnings: <span class="hljs-number">0
<span class="hljs-keyword">...
[root@node9 ~]<span class="hljs-comment"># mysql -uroot -p
Enter password:
ERROR <span class="hljs-number">1275 (HY000): Server is running <span class="hljs-keyword">in --secure-auth mode, but <span class="hljs-string">‘root‘@<span class="hljs-string">‘localhost‘ has a password <span class="hljs-keyword">in the old format; please change the password to the new format
<span class="hljs-keyword">...</span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></code>

Linux MariaDB 遗忘密码后重置密码

标签：tables   password   查看   ror   run   int   emctl   war   iad