添加 database:
mysql create database xhkdb;
添加用户:
insert into mysql.user(Host,User,Password) values("localhost","test",password("1234"));
flush privileges; //没有这一步,无法登陆。
删除用户:
Use mysql;
Delete FROM user Where User='test' and Host='localhost';
更换密码
mysql>update mysql.user set password=password('新密码') where User="test" and Host="localhost";
mysql>flush privileges;
http://www.cnblogs.com/wanghetao/p/3806888.html