时间:2021-07-01 10:21:17 帮助过:36人阅读
出现“Active: inactive (dead)”表示数据库已关闭,如果是“Active: active (exited)”表示已开启,需要手动关闭:
- <span style="color: #008080;">1</span> [root@localhost ~]# systemctl stop mysql
找到MySQL的配置文件“my.cnf”,默认路径是:“/etc/my.cnf”。
打开文件并在“[mysqld]”下添加:
- <span style="color: #008080;">1</span> skip-grant-tables
这句话的作用是在登录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