1 新建用戶
mysql -u root -p
輸入密碼
后進入mysql 命令行管理
insert into mysql.user(Host,User,Password) values('localhost','admin',password('123456'));
//刷新系統權限表
mysql> flush privileges;
2創建數據庫
create database newdatabase;
3為用戶授權
mysql>grant all privileges on newdatabase.* to admin@localhost identified by '123456';
mysql>flush privileges;
也可以授予該用戶特定的權限
grant select, insert,update,delete on newdatabase.* to admin@localhost identified by '123456';
共14種權限 select,insert,update,delete,create,drop,index,alter,grant,references,reload,shutdown,process,file
mysql>grant all privileges on vtdc.* to joe@10.163.225.87 identified by ‘123′;
給來自10.163.225.87的用戶joe分配可對數據庫vtdc所有表進行所有操作的權限，并設定口令為123。
mysql>grant all privileges on *.* to joe@10.163.225.87 identified by ‘123′;
給來自10.163.225.87的用戶joe分配可對所有數據庫的所有表進行所有操作的權限，并設定口令為123。
mysql>grant all privileges on *.* to joe@localhost identified by ‘123′;
給本機用戶joe分配可對所有數據庫的所有表進行所有操作的權限，并設定口令為123。
4.刪除用戶
@>mysql -u root -p
@>密碼
mysql>DELETE FROM user WHERE User="phplamp" and Host="localhost";
mysql>flush privileges;
//刪除用戶的數據庫
mysql>drop database phplampDB;
5.修改指定用戶密碼
@>mysql -u root -p
@>密碼
mysql>update mysql.user set password=password('新密碼') where User="phplamp" and Host="localhost";
mysql>flush privileges;
mysql>quit;