适用于mysql 8.0的常用操作

一、创建用户

CREATE USER 'username'@'localhost' IDENTIFIED BY 'password';

二、更改验证方式及用户密码

ALTER USER 'username'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';

三、权限设置

GRANT ALL ON *.* TO 'username'@'localhost';