mysql´´½¨Óû§È¨ÏÞÓï·¨

create database testdb; /* ´´½¨Êý¾Ý¿â */
use testdb; /* ´ò¿ªÊý¾Ý¿â */
/*grant ÆÕͨÊý¾ÝÓû§£¬²éѯ¡¢²åÈë¡¢¸üС¢É¾³ý Êý¾Ý¿âÖÐËùÓбíÊý¾ÝµÄȨÀû*/
grant select,insert,update,delete on testdb.* to common_user@'%';
grant select,insert,update,delete on testdb.* to common_user@'localhost';
/* (.*´ú±íËùÓбí) @ºóµÄ%´ú±íËùÓÐÓû§£¬±¾µØ£¬Ô¶³Ì¶¼¿ÉÒÔͨ¹ýÍøÂç·ÃÎÊ£¬@localhost,@'192.168.1.101' ¼ÓÃÜidentified by '123' */
/* grant Êý¾Ý¿â¿ª·¢ÈËÔ±£¬´´½¨±í¡¢Ë÷Òý¡¢ÊÓͼ¡¢´æ´¢¹ý³Ì¡¢º¯Êý¡£¡£¡£µÈȨÏÞ */
grant create,alter,drop on testdb.* to common_user@localhost; /* grant ´´½¨¡¢Ð޸ġ¢É¾³ý MySQL Êý¾Ý±í½á¹¹È¨ÏÞ¡£ */
grant references on testdb.* to common_user@localhost; /* grant ²Ù×÷ MySQL Íâ¼üȨÏÞ */
grant create temporary tables on testdb.* to common_user@localhost; /* grant ²Ù×÷ MySQL ÁÙʱ±íȨÏÞ */
grant index on testdb.* to common_user@localhost; /* grant ²Ù×÷ MySQL Ë÷ÒýȨÏÞ */
grant create view on testdb.*to common_user@localhost; /* ²Ù×÷ MySQL ÊÓͼ¡¢²é¿´ÊÓͼԴ´úÂë ȨÏÞ */
grant show view on testdb.* to common_user@localhost;
/* grant ²Ù×÷ MySQL ´æ´¢¹ý³Ì¡¢º¯Êý ȨÏÞ */
grant create routine on testdb.* to common_user@localhost;
grant alter routine on testdb.* to common_user@localhost;
grant execute on testdb.* to common_user@localhost;
flush privileges;