mysql新增用户及赋予权限

CREATE USER 'yishun'@'host' IDENTIFIED BY 'password';
UPDATE USER set Select_priv = "Y",Insert_priv = "Y",Update_priv ="Y",Delete_priv="Y",Create_priv = "Y",`Host`="%" where `User` = "yishun"

//创建账号，设置权限和可被访问为所有

flush privileges; /*刷新权限*/

CREATE USER 'yishun'@'localhost' IDENTIFIED BY 'yishun';

GRANT SELECT,DELETE,INSERT,UPDATE ON mysql.user TO 'yishun'@'%';
 GRANT ALL ON *.* TO 'root'@'%'

grant all privileges on newyishun.* to 'yishun'@'%';

grant select on newyishun.* to 'yishun'@'localhost'; /*给予查询权限*/

grant insert on newyishun.* to 'yishun'@'localhost'; /*添加插入权限*/

grant delete on newyishun.* to 'yishun'@'localhost'; /*添加删除权限*/

grant update on newyishun.* to 'yishun'@'localhost'; /*添加权限*/

　 flush privileges; /*刷新权限*/

grant all privileges on newyishun.* to yishun@'%'

grant all privileges on . to 'root'@'%';