mysql8 用户和授权管理

删除用户

drop user 'schedule-service'@'%';

 

删除授权

revoke all privileges on schedule_service.* from 'schedule-service'@'%';

 

创建用户

create user 'schedule-service'@'%' identified with mysql_native_password BY 'schedule-service';

 

授权

grant all privileges on schedule_service.* to 'schedule-service'@'%';
​
flush privileges;