mysql 创建一个用户 xkcms，密码 xkcms，指定一个数据库 xkcmsdb 给 xkcms
mysql -u root -p
password
use mysql;
insert into user(host,user,password) values('localhost','xkcms',password('xkcms'));
flush privileges;
create database xkcmsdb;
grant all privileges on xkcmsdb.* to xkcms@localhost identified by 'xkcms';
flush privileges;
如果想指定部分权限给用户
grant select,update on xkcmsdb.* to xkcms@localhost identified by 'xkcms';
flush privileges;
删除用户
delete from user where user='xkcms' and host='localhost';
flush privileges;
删除用户数据库
drop database xkcmsdb;
修改指定用户密码
update user set password=password('new_password') where user='xkcms' and host='localhost';
flush privileges;