mysql 重建帐号

偏执的太偏执、 2022-07-13 06:55 150阅读 0赞

mysql 因某些原因帐户被破坏。需要重建  
一、模拟删除破坏用户：  
lixiaomeng:~ \# mysql -uroot -proot  
mysql> use mysql;  
mysql> select user,host from user;  
\+----------+------------+  
| user     | host       |  
\+----------+------------+  
| lixiaomeng| %          |  
| lixiaomeng| 127.0.0.1  |  
| root     | 127.0.0.1  |  
| root     | ::1        |  
| root     | lixiaomeng |  
| lixiaomeng | localhost  |  
| root     | localhost  |  
| lixiaomeng | lixiaomeng  |  
\+----------+------------+  
8 rows in set (0.00 sec)  
mysql> delete from user where user='root';  
Query OK, 4 rows affected (0.00 sec)  
mysql> select user,host from user;  
\+----------+-----------+  
| user     | host      |  
\+----------+-----------+  
| lixiaomeng | %         |  
| lixiaomeng | 127.0.0.1 |  
| lixiaomeng | localhost |  
| lixiaomeng | lixiaomeng |  
\+----------+-----------+  
4 rows in set (0.00 sec)  
mysql>  
lixiaomeng:~ \# service mysql restart  
Shutting down MySQL..                                                                                                                                                 done  
Starting MySQL.                                                                                                                                                       done  
lixiaomeng:~ \# mysql -uroot -proot  
Warning: Using a password on the command line interface can be insecure.  
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)  
lixiaomeng:~ \#  
   
二、重建本地用户：  
lixiaomeng:/etc \# vi my.cnf   
\[mysqld\]  
skip-grant-tables  
lixiaomeng:~ \# service mysql restart  
Shutting down MySQL..                                                                                                                                                 done  
Starting MySQL.                      
lixiaomeng:~ \# mysql -uroot -p  
Enter password:   
mysql> insert into mysql.user (host, user, password,ssl\_cipher,x509\_issuer,x509\_subject) values ('localhost', 'root', password('root'),'','','');  
Query OK, 1 row affected (0.00 sec)  
mysql> flush privileges;  
Query OK, 0 rows affected (0.00 sec)  
mysql> grant all privileges on \*.\* to 'root'@'localhost' identified by 'root' with grant option;  
Query OK, 0 rows affected (0.00 sec)  
mysql>  
lixiaomeng:/etc \# vi my.cnf   
\[mysqld\]  
\#skip-grant-tables  
lixiaomeng:~ \# service mysql restart  
Shutting down MySQL..                                                                                                                                                 done  
Starting MySQL.                                                                                                                                                       done  
三、通过本地用户重建远程用户：  
lixiaomeng:~ \# mysql -uroot -proot  
mysql> select user,host from mysql.user;  
\+----------+-----------+  
| user     | host      |  
\+----------+-----------+  
| lixiaomeng | %         |  
| lixiaomeng | 127.0.0.1 |  
| lixiaomeng | localhost |  
| root     | localhost |  
| lixiaomeng | lixiaomeng |  
\+----------+-----------+  
5 rows in set (0.00 sec)  
mysql>  grant all privileges on \*.\* to 'root'@'%' identified by 'root' with grant option;  
Query OK, 0 rows affected (0.00 sec)  
mysql> select user,host from mysql.user;  
\+----------+-----------+  
| user     | host      |  
\+----------+-----------+  
| lixiaomeng | %         |  
| root     | %         |  
| lixiaomeng | 127.0.0.1 |  
| lixiaomeng | localhost |  
| root     | localhost |  
| lixiaomeng| lixiaomeng|  
\+----------+-----------+  
6 rows in set (0.00 sec)