mysql 之如何修复删除用户表

1.

mysql> flush privileges;

#授权

2.

mysql> grant all on *.* to root@'localhost' identified by '123';

# 创建用户并授权

 

3.

授权超级用户
grant all on *.* to root@'localhost' identified by '123' with grant option;

 

4. 如何跳过授权

跳过授权表启动mysql
[root@db01 ~]# mysqld_safe --skip-grant-tables --skip-networking &

转载于:https://www.cnblogs.com/gukai/p/10839541.html