mysql添加用户和指定IP授权和回收相关操作

-- 创建用户
CREATE USER user[IDENTIFIED BY [PASSWORD] 'password'], 
[user[IDENTIFIED BY [PASSWORD] 'password']]...
CREATE USER 'chwit'@'%' IDENTIFIED BY 'SXyVYtUkqh0b3rJ';
-- 授权
GRANT ALL ON *.* to itsm@'192.168.168.164' IDENTIFIED BY '*******'; 
GRANT ALL ON chwdms.* to chwit@'%' IDENTIFIED BY 'SXyVYtUkqh0b3rJ'; 

--创建数据库指定字符集
CREATE DATABASE IF NOT EXISTS yourdbname DEFAULT CHARSET utf8 COLLATE utf8_general_ci;

-- 回收
--下面的代码实现了取消sss用户的所有权限的功能。
revoke all on *.* from sss@localhost ;

-- 重置密码：
use mysql; 
update user set password=password("") where user=’root’ and host=’localhost’; flush privileges;