1.

mysql> flush privileges;

SRE实战 互联网时代守护先锋，助力企业售后服务体系运筹帷幄！一键直达领取阿里云限量特价优惠。

#授权

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 &

扫码关注我们
微信号：SRE实战
拒绝背锅 运筹帷幄