#眉標=MySQL、grant on、revoke on
#副標=MySQL Server開發應用（2）
#大標=MySQL帳號與權限設定
#作者=文／圖	葉建榮



===<反灰>=============
grant 權限 on 資料庫.資料表 to 帳號@主機 identified by‘密碼’
==<end>==============





===<反灰>=============
grant all privileges on *.* to pcschool@localhost identified by 'phpmysql' ;
==<end>==============



===<反灰>=============
grant  all privileges  on  board.*  to  php1@localhost identified by 'mysqlstart1' ;
==<end>==============





===<反灰>=============
grant all privileges on board2.* to php1@localhost identified by 'mysqlstart1';
==<end>==============




===<反灰>=============
grant all privileges on board2.test to php2@localhost identified by 'mysqlstart2';
==<end>==============




===<反灰>=============
grant select on  *.* to php3@localhost identified by 'mysqlstart3';
==<end>==============




===<反灰>=============
revoke 權限 on 資料庫.資料表 from 帳號@主機
==<end>==============




===<反灰>=============
revoke delete on *.* from pcschool@localhost;
==<end>==============




===<反灰>=============
revoke all privileges on *.* from pcschool@localhost;
==<end>==============