MYSQLÊÚȨ

mysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP
    ->     ON bankaccount.*
    ->     TO 'custom'@'localhost'
    ->     IDENTIFIED BY 'password';
mysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP
    ->     ON expenses.*
    ->     TO 'custom'@'whitehouse.gov'
    ->     IDENTIFIED BY 'password';
mysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP
    ->     ON customer.*
    ->     TO 'custom'@'server.domain'
    ->     IDENTIFIED BY 'password';
mysql> drop user;
mysql> revoke insert
    ->     on  customer.*
    ->     from 'custom'@'server.domain';
ȨÏÞ£¨privilege£©£º
CREATE 
DROP 
ALTER 
DELETE 
INDEX 
INSERT 
SELECT 
UPDATE 
CREATE VIEW 
SHOW VIEW 
ALTER ROUTINE 
CREATE ROUTINE 
EXECUTE 
FILE 
CREATE TEMPORARY TABLES 
LOCK TABLES 
CREATE USER 
PROCESS 
RELOAD 
REPLICATION CLIENT 
REPLICATION SLAVE
SHOW DATABASES 
SHUTDOWN 
SUPER 
MysqlÃÜÂëÍü¼ÇÁËÔõô°ì£¿
------------------------------------------------------------
·Ö±ðÔÚWindowsϺÍLinuxÏÂÖØÖÃÁËMYSQLµÄrootµÄÃÜÂ룬ÕûÀíÈçÏ£º
ÔÚwindowsÏ£º
´ò¿ªÃüÁîÐд°¿Ú£¬Í£Ö¹mysql·þÎñ£ºNet stop mysql
µ½mysqlµÄ°²×°Â·¾¶Æô¶¯mysql£¬ÔÚbinĿ¼ÏÂʹÓÃmysqld-nt.exeÆô¶¯£¬
ÔÚÃüÁîÐд°¿ÚÖ´ÐУºmysqld-nt --skip-grant-tables
È»ºóÁíÍâ´ò¿ªÒ»¸öÃüÈëÁîÐд°¿Ú£¬Ö´ÐÐmysql£¬´ËʱÎÞÐèÊäÈëÃÜÂë¼´¿É½øÈë¡£
>use mysql  
>update user set password=password("ÐÂÃÜÂë") where user="root";  
>flush privileges;  
>