当前位置:Gxlcms > 数据库问题 > MySQL补充——忘记密码怎么办

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

时间:2021-07-01 10:21:17 帮助过:36人阅读

[root@localhost ~]# systemctl status mysql

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

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

修改MySQL的配置文件

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

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

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

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

保存修改并退出。

启动MySQL

使用命令启动MySQL:

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

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

修改密码

连接“mysql”数据库,修改用户密码:

  1. <span style="color: #008080;"> 1</span> mysql><span style="color: #000000;"> use mysql;
  2. </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
  3. </span><span style="color: #008080;"> 3</span> You can turn off this feature to get a quicker startup with -<span style="color: #000000;">A
  4. </span><span style="color: #008080;"> 4</span>
  5. <span style="color: #008080;"> 5</span> <span style="color: #000000;">Database changed
  6. </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;">;
  7. </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)
  8. </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>
  9. <span style="color: #008080;"> 9</span>
  10. <span style="color: #008080;">10</span> mysql>

将root用户的密码设为123456。

刷新使改动生效:

  1. <span style="color: #008080;">1</span> mysql><span style="color: #000000;"> flush privileges;
  2. </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,需要密码登录,输入设置的密码即可:

  1. <span style="color: #008080;"> 1</span> [root@localhost ~]# vim /etc/<span style="color: #000000;">my.cnf
  2. </span><span style="color: #008080;"> 2</span> [root@localhost ~<span style="color: #000000;">]# systemctl restart mysql
  3. </span><span style="color: #008080;"> 3</span> [root@localhost ~<span style="color: #000000;">]# mysql
  4. </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)
  5. </span><span style="color: #008080;"> 5</span> [root@localhost ~]# mysql -u root -<span style="color: #000000;">p
  6. </span><span style="color: #008080;"> 6</span> <span style="color: #000000;">Enter password:
  7. </span><span style="color: #008080;"> 7</span> <span style="color: #000000;">Welcome to the MySQL monitor. Commands end with ; or \g.
  8. </span><span style="color: #008080;"> 8</span> Your MySQL connection <span style="color: #0000ff;">id</span> is <span style="color: #800080;">4</span>
  9. <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)
  10. </span><span style="color: #008080;">10</span>
  11. <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.
  12. </span><span style="color: #008080;">12</span>
  13. <span style="color: #008080;">13</span> Oracle is a registered trademark of Oracle Corporation and/<span style="color: #000000;">or its
  14. </span><span style="color: #008080;">14</span> <span style="color: #000000;">affiliates. Other names may be trademarks of their respective
  15. </span><span style="color: #008080;">15</span> <span style="color: #000000;">owners.
  16. </span><span style="color: #008080;">16</span>
  17. <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.
  18. </span><span style="color: #008080;">18</span>
  19. <span style="color: #008080;">19</span> mysql>

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

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

人气教程排行