添加删除mysql用户

create user 'hive_user'@'%' identified by '密码';
grant all privileges on hive.* to hive_user@'%';

create user 'hive_user'@'localhost' identified by '密码'; 
grant all privileges on hive.* to hive_user@'localhost';

 

grant all privileges on dc_bj_data.* to dc_user@'%' identified by '123';

grant select,delete,update,create,drop on *.* to test@"%" identified by '123';

grant select on dc_bj_data.sanshengsanshi_log to test@"%" identified by '123';

Delete FROM mysql.user Where User='dc_user';