-- 如果用户存在删除用户
DROP USER 'test'@'%';
-- 创建test用户并赋密码
CREATE USER 'test'@'%' IDENTIFIED BY '123456';
-- 给账号权限(查询、修改权限)
grant select,update on test.user to 'test'@'%'
-- 解决mysql8报错:ERROR 1410 (42000): You are not allowed to create a user with GRANT解决办法
alter user 'test' identified with mysql_native_password by '123456'
-- 刷新权限
FLUSH PRIVILEGES;