mysqldinitializeconsole失败_mysql03误删除了所有用户解决办法

误删除了所有用户解决办法

第一种方法(企业常用)

1.将数据库down掉

[root&＃64;db03 mysql]# /etc/init.d/mysqld stopShutting down MySQL.. SUCCESS! [root&＃64;db03 mysql]# mysqlERROR 2002 (HY000): Can&＃39;t connect to local MySQL server through socket &＃39;/opt/mysql-5.6.44/tmp/mysql.sock&＃39; (2)

2.给/opt/目录下所有受mysql用户权限

[root&＃64;db03 mysql]# chown -R mysql.mysql /opt/*

3.启动数据库

[root&＃64;db03 ~]# mysqld_safe --skip-grant-tables --skip-networking &

4.进入数据库

[root&＃64;db03 ~]# mysql

5.初始化

mysql> flush privileges;Query OK, 0 rows affected (0.01 sec)

6.设置数据库用户权限和密码

mysql> grant all on *.* to root&＃64;&＃39;localhost&＃39; identified by &＃39;1&＃39; with grant option;Query OK, 0 rows affected (0.00 sec)

7.退出重启数据库

mysql> q [root&＃64;db03 mysql]# /etc/init.d/mysqld restar

8.进入数据库查看

mysql> select user,host from mysql.user;&＃43;------&＃43;-----------&＃43;| user | host |&＃43;------&＃43;-----------&＃43;| root | localhost |&＃43;------&＃43;-----------&＃43;1 row in set (0.01 sec)

第二种方法

1.down掉数据库

[root&＃64;db04 scripts]# /etc/init.d/mysqld stopShutting down MySQL.. SUCCESS!

2.启动数据库

[root&＃64;db04 scripts]# mysqld_safe --skip-grant-tables --skip-networking & [1] 25934

3.进入数据库

[root&＃64;db04 scripts]# mysql

4.使用数据库

mysql> use mysql Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed

5.创建root用户

mysql> insert into mysql.user values (&＃39;localhost&＃39;,&＃39;root&＃39;,PASSWORD(&＃39;123&＃39;), -> &＃39;Y&＃39;, -> &＃39;Y&＃39;, -> &＃39;Y&＃39;, -> &＃39;Y&＃39;, -> &＃39;Y&＃39;, -> &＃39;Y&＃39;, -> &＃39;Y&＃39;, -> &＃39;Y&＃39;, -> &＃39;Y&＃39;, -> &＃39;Y&＃39;, -> &＃39;Y&＃39;, -> &＃39;Y&＃39;, -> &＃39;Y&＃39;, -> &＃39;Y&＃39;, -> &＃39;Y&＃39;, -> &＃39;Y&＃39;, -> &＃39;Y&＃39;, -> &＃39;Y&＃39;, -> &＃39;Y&＃39;, -> &＃39;Y&＃39;, -> &＃39;Y&＃39;, -> &＃39;Y&＃39;, -> &＃39;Y&＃39;, -> &＃39;Y&＃39;, -> &＃39;Y&＃39;, -> &＃39;Y&＃39;, -> &＃39;Y&＃39;, -> &＃39;Y&＃39;, -> &＃39;Y&＃39;, -> &＃39;&＃39;, -> &＃39;&＃39;, -> &＃39;&＃39;, -> &＃39;&＃39;,0,0,0,0,&＃39;mysql_native_password&＃39;,&＃39;&＃39;,&＃39;N&＃39;);

6.查看用户

mysql> select user,host from mysql.user;&＃43;------&＃43;-----------&＃43;| user | host |&＃43;------&＃43;-----------&＃43;| root | localhost |&＃43;------&＃43;-----------&＃43;1 row in set (0.00 sec)

第三种方法(企业不可用,数据会丢失)

1.down掉数据库

[root&＃64;db04 ~]# /etc/init.d/mysqld stopShutting down MySQL.. SUCCESS!

2.删除或改名/opt/mysql/data目录

[root&＃64;db04 opt]# cd mysql [root&＃64;db04 mysql]# mv data date [root&＃64;db04 mysql]# rm -fr data

3.初始化

[root&＃64;db04 scripts]# ./mysql_install_db --datadir&＃61;/opt/mysql/data --basedir&＃61;/opt/mysql -- user&＃61;mysql [root&＃64;db04 scripts]# echo $?0

4.授权

[root&＃64;db04 scripts]# chown -R mysql.mysql /opt/*

5.启动数据库

[root&＃64;db04 scripts]# /etc/init.d/mysqld start Starting MySQL.Logging to &＃39;/opt/mysql/data/db04.err&＃39;. SUCCESS!

6.进入数据库查看

[root&＃64;db04 scripts]# mysqlmysql> select user,host from mysql.user;&＃43;------&＃43;-----------&＃43;| user | host |&＃43;------&＃43;-----------&＃43;| root | % || root | 127.0.0.1 || root | ::1 || | db02 || root | db02 || | localhost || root | localhost |&＃43;------&＃43;-----------&＃43;7 rows in set (0.00 sec)