Mysql用户操作

创建用户

CREATE USER 'video'@'%' IDENTIFIED BY 'video2019';

.限制用户权限

GRANT SELECT, INSERT, UPDATE, REFERENCES, DELETE, CREATE, DROP, ALTER, INDEX, CREATE VIEW, SHOW VIEW ON `video_fastadmin`.* TO 'video'@'%';

授权

GRANT ALL PRIVILEGES ON video_fastadmin.* TO 'video'@'%';