一、创建用户
CREATE USER 'username'@'localhost' IDENTIFIED BY 'password';
二、更改验证方式及用户密码
ALTER USER 'username'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
三、权限设置
GRANT ALL ON *.* TO 'username'@'localhost';
一、创建用户
CREATE USER 'username'@'localhost' IDENTIFIED BY 'password';
二、更改验证方式及用户密码
ALTER USER 'username'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
三、权限设置
GRANT ALL ON *.* TO 'username'@'localhost';