mysql增加用户 (%代表可以登录ip)
CREATE USER 'hive'@'%' IDENTIFIED BY 'hive';
权限赋予:
grant select,delete,update,create,drop on test_hive.* to 'hive'@'%' identified by '123456';
赋予所有权 (hive并与database,*表与表)
grant all privileges on hive.* to 'hive'@'%' identified by 'hive';
删除账户
drop user 'hive'@'%';
修改用户密码
ALTER USER 'win'@'%' IDENTIFIED BY '123456';