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';