mysql添加用户、添加权限
建立数据库dnspod
create database dnspod;
1.添加用户
grant all on 数据库名.* to 用户名@localhost identified by '密码';
grant all on dnspod.* to huituzi@localhost identified by 'password';
2.删除用户
mysql> mysql>Delete FROM user Where User="huituzi" and Host="localhost"; mysql>flush privileges; //刷新用户权限
3. 修改密码
huituzi
mysqladmin -u
