Mysql 8.0版本以上创建用户及授权

1. 创建用户：create user 'dba'@'%' IDENTIFIED BY 'MyPass@123';
2. 授权：grant all privileges on *.* to 'dba'@'%'; 
3. 设置密码：alter user 'dba'@'%' IDENTIFIED WITH mysql_native_password BY 'MyPass@123';
4. 刷新权限：FLUSH PRIVILEGES;
5. 修改root用户密码：UPDATE user SET Password = PASSWORD('newpass') WHERE user = 'root';
6. 丢失root密码：在my.cnf配置文件中mysqld_safe下添加 --skip-grant-tables，重启服务后就可以免密登录，然后执行：UPDATE user SET password=PASSWORD("new password") WHERE user='root'，删掉配置中 --skip-grant-tables，重启服务就可以了；