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)
mysql 重建注册_mysql 重建帐号
最新推荐文章于 2022-02-06 16:19:35 发布