mysql 重建注册_mysql 重建帐号

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)