1 新建用戶
mysql -u root -p
輸入密碼
后進(jìn)入mysql 命令行管理
insert into mysql.user(Host,User,Password) values('localhost','admin',password('123456'));
//刷新系統(tǒng)權(quán)限表
mysql> flush privileges;
2創(chuàng)建數(shù)據(jù)庫
create database newdatabase;
3為用戶授權(quán)
mysql>grant all privileges on newdatabase.* to admin@localhost identified by '123456';
mysql>flush privileges;
也可以授予該用戶特定的權(quán)限
grant select, insert,update,delete on newdatabase.* to admin@localhost identified by '123456';
共14種權(quán)限 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分配可對數(shù)據(jù)庫vtdc所有表進(jìn)行所有操作的權(quán)限，并設(shè)定口令為123。
mysql>grant all privileges on *.* to joe@10.163.225.87 identified by ‘123′;
給來自10.163.225.87的用戶joe分配可對所有數(shù)據(jù)庫的所有表進(jìn)行所有操作的權(quán)限，并設(shè)定口令為123。
mysql>grant all privileges on *.* to joe@localhost identified by ‘123′;
給本機(jī)用戶joe分配可對所有數(shù)據(jù)庫的所有表進(jìn)行所有操作的權(quán)限，并設(shè)定口令為123。
4.刪除用戶
@>mysql -u root -p
@>密碼
mysql>DELETE FROM user WHERE User="phplamp" and Host="localhost";
mysql>flush privileges;
//刪除用戶的數(shù)據(jù)庫
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;