init

#创建用户、授权
grant all on bsnportal.* to bsnp_user@'localhost' identified by 'bsnzj@8btc.COM';
#查询用户
select host,user,password from mysql.user;
#修改密码
set password for 'username'@'host' = password('newpassword')
#删除用户
delete from mysql.user Where User='bsnp_user' and Host='%';
#刷新缓存
flush privileges;
#登录client
mysql -ubsnp_user -pbsnzj@8btc.COM