Mysql创建账号并且赋予权限

--- 创建新账号

CREATE USER 'thymeleaf' IDENTIFIED BY 'jwbasta-thymeleaf-admin';

CREATE USER 'jwbasta-vue' IDENTIFIED BY 'jwbasta-vue-admin';

CREATE USER 'vue' IDENTIFIED BY 'jwbasta-vue-admin';

-- 赋予一个数据权限

grant all privileges on jwbasta_admin.* to 'thymeleaf'@'%' identified by 'jwbasta-thymeleaf-admin' with grant option;

grant all privileges on jwbasta_vue.* to 'vue'@'%' identified by 'jwbasta-vue-admin' with grant option;

-- 刷新权限

flush privileges;

--- 数据库有查询、插入、修改、删除的权限

grant select,insert,update,delete on jwbasta_admin.* to thymeleaf@'%' Identified by 'jwbasta-thymeleaf-admin';

grant all on jwbasta_admin.* to thymeleaf@'%' Identified by 'jwbasta-thymeleaf-admin';

grant all on jwbasta_vue.* to vue@'%' Identified by 'jwbasta-vue-admin';