給權限

//給testacc table1資料庫的select,insert,update,delete權限
grant select,insert,update,delete on table1.* to testacc;

//新增使用者root，可由任何地方登入，密碼為pass --此句話法無Grant_priv權限
grant all privileges on  *.* to root@'%' identified by 'pass';

//新增使用者acc有root權限，可由任何地方登入，密碼為pass
grant all privileges on  *.* to acc@'%' identified by 'pass' with grant option;


//給帳號root的權限
grant all on *.* to testacc with grant option;