MySQL补充——忘记密码怎么办

出现“Active: inactive (dead)”表示数据库已关闭，如果是“Active: active (exited)”表示已开启，需要手动关闭：

<span style="color: #008080;">1</span> [root@localhost ~]# systemctl stop mysql

修改MySQL的配置文件

找到MySQL的配置文件“my.cnf”，默认路径是：“/etc/my.cnf”。

打开文件并在“[mysqld]”下添加：

<span style="color: #008080;">1</span> skip-grant-tables

这句话的作用是在登录MySQL的时候可以跳过密码直接登录。

保存修改并退出。

启动MySQL

使用命令启动MySQL：

<span style="color: #008080;">1</span> [root@localhost ~]# systemctl start mysql

输入“mysql”即可进入数据库。

修改密码

连接“mysql”数据库，修改用户密码：

<span style="color: #008080;"> 1</span> mysql><span style="color: #000000;"> use mysql;
</span><span style="color: #008080;"> 2</span> Reading table information <span style="color: #0000ff;">for</span><span style="color: #000000;"> completion of table and column names
</span><span style="color: #008080;"> 3</span> You can turn off this feature to get a quicker startup with -<span style="color: #000000;">A
</span><span style="color: #008080;"> 4</span> 
<span style="color: #008080;"> 5</span> <span style="color: #000000;">Database changed
</span><span style="color: #008080;"> 6</span> mysql> update mysql.user set password=password(<span style="color: #800000;">‘</span><span style="color: #800000;">123456</span><span style="color: #800000;">‘</span>) where user=<span style="color: #800000;">‘</span><span style="color: #800000;">root</span><span style="color: #800000;">‘</span><span style="color: #000000;">;
</span><span style="color: #008080;"> 7</span> Query OK, <span style="color: #800080;">5</span> rows affected (<span style="color: #800080;">0.00</span><span style="color: #000000;"> sec)
</span><span style="color: #008080;"> 8</span> Rows matched: <span style="color: #800080;">5</span>  Changed: <span style="color: #800080;">5</span>  Warnings: <span style="color: #800080;">0</span>
<span style="color: #008080;"> 9</span> 
<span style="color: #008080;">10</span> mysql>

将root用户的密码设为123456。

刷新使改动生效：

<span style="color: #008080;">1</span> mysql><span style="color: #000000;"> flush privileges;
</span><span style="color: #008080;">2</span> Query OK, <span style="color: #800080;">0</span> rows affected (<span style="color: #800080;">0.00</span> sec)

回改文件并重启

退出MySQL，重新打开“my.cnf”配置文件，删除“skip-grant-tables”，保存退出。

重启MySQL，需要密码登录，输入设置的密码即可：

<span style="color: #008080;"> 1</span> [root@localhost ~]# vim /etc/<span style="color: #000000;">my.cnf
</span><span style="color: #008080;"> 2</span> [root@localhost ~<span style="color: #000000;">]# systemctl restart mysql
</span><span style="color: #008080;"> 3</span> [root@localhost ~<span style="color: #000000;">]# mysql
</span><span style="color: #008080;"> 4</span> ERROR <span style="color: #800080;">1045</span> (<span style="color: #800080;">28000</span>): Access denied <span style="color: #0000ff;">for</span> user <span style="color: #800000;">‘</span><span style="color: #800000;">root</span><span style="color: #800000;">‘</span>@<span style="color: #800000;">‘</span><span style="color: #800000;">localhost</span><span style="color: #800000;">‘</span><span style="color: #000000;"> (using password: NO)
</span><span style="color: #008080;"> 5</span> [root@localhost ~]# mysql -u root -<span style="color: #000000;">p
</span><span style="color: #008080;"> 6</span> <span style="color: #000000;">Enter password:
</span><span style="color: #008080;"> 7</span> <span style="color: #000000;">Welcome to the MySQL monitor.  Commands end with ; or \g.
</span><span style="color: #008080;"> 8</span> Your MySQL connection <span style="color: #0000ff;">id</span> is <span style="color: #800080;">4</span>
<span style="color: #008080;"> 9</span> Server version: <span style="color: #800080;">5.6</span>.<span style="color: #800080;">45</span><span style="color: #000000;"> MySQL Community Server (GPL)
</span><span style="color: #008080;">10</span> 
<span style="color: #008080;">11</span> Copyright (c) <span style="color: #800080;">2000</span>, <span style="color: #800080;">2019</span>, Oracle and/<span style="color: #000000;">or its affiliates. All rights reserved.
</span><span style="color: #008080;">12</span> 
<span style="color: #008080;">13</span> Oracle is a registered trademark of Oracle Corporation and/<span style="color: #000000;">or its
</span><span style="color: #008080;">14</span> <span style="color: #000000;">affiliates. Other names may be trademarks of their respective
</span><span style="color: #008080;">15</span> <span style="color: #000000;">owners.
</span><span style="color: #008080;">16</span> 
<span style="color: #008080;">17</span> Type <span style="color: #800000;">‘</span><span style="color: #800000;">help;</span><span style="color: #800000;">‘</span> or <span style="color: #800000;">‘</span><span style="color: #800000;">\h</span><span style="color: #800000;">‘</span> <span style="color: #0000ff;">for</span> help. Type <span style="color: #800000;">‘</span><span style="color: #800000;">\c</span><span style="color: #800000;">‘</span> to <span style="color: #0000ff;">clear</span><span style="color: #000000;"> the current input statement.
</span><span style="color: #008080;">18</span> 
<span style="color: #008080;">19</span> mysql>

MySQL补充——忘记密码怎么办

标签：its   local   oca   root   ges   开启   oracle   match   gis