1-创建用户语法
- 执行相关语句
create user '用户名'@'IP地址' identified WITH mysql_native_password by '密码';
- 刷新
flush privileges;
2.举例
CREATE USER 'alian'@'%' IDENTIFIED WITH mysql_native_password BY'123456';flush privileges;
create user '用户名'@'IP地址' identified WITH mysql_native_password by '密码';
flush privileges;
CREATE USER 'alian'@'%' IDENTIFIED WITH mysql_native_password BY'123456';flush privileges;
