查看mysql编码
show variables like '%character%';
添加用户:
CREATE USER 'dev'@'%' IDENTIFIED BY '123456';
赋予权限:
grant create,select,update on dev_db.* to dev@"%" identified by '123456'; //dev用户只有dev_db下的create,select,update权限
grant all on dev_db.* to dev@"%" identified by '123456'; //dev用户有所有db下的create,select,update权限
grant all on *.* to dev@"%" identified by '123456'; //dev用户有所有db下的所有权限
最后要执行:
flush privileges;
删除用户:
delete FROM user Where User='test' and Host='localhost';
flush privileges;