Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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;


Ïà¹ØÎĵµ£º

windows7ϰ²×°apache+php+mysqlÎÊÌâ¼Ç¼

×î½üÐÂÂòÁ˸öµçÄÔ£¬ÏµÍ³ÊÇwindows7£¬window7ÔÚ½çÃæ£¬¹¦ÄÜ·½Ã涼ͦÈÃÈËÂúÒâµÄ£¬¸Ð¾õºÜˬ£¬²»Ë¬µÄÊÇÓÖÒªÖØÐ°²×°»·¾³ÁË¡£
ËùÓÐÈí¼þ¾ù°²×°ÔÚF:\server\ÏÂ
apacheĿ¼£ºF:\server\apache2.2
phpĿ¼£ºF:\server\php
msyqlĿ¼£ºF:\server\mysql
Ò»¡¢°²×°apache
°²×°apacheµÄ°æ±¾ÊÇ£ºhttpd-2.2.15-win32-x86-no_ssl.msi
° ......

¹ØÓÚmysql¹Ø¼ü×Ö

×òÌìΪһ¸öÏîÄ¿×öÊý¾Ý¿â£¬ÏîÄ¿Éæ¼°µ½¶©µ¥£¬ÔÚÉè¼ÆÊý¾Ý¿â×ÖµäµÄʱºò ¾Í°ÑÕâ¸ö±íÃû¶¨ÎªÁËorder£¬½¨±íµÄʱºòÔõô½¨¶¼²»¶Ô£¬ÌáʾÊDZíÃû¸½½ü³öÏÖÎÊÌ⣬µ±Ê±¾õµÃ²»¿ÉÄܰ¡ Ò²ÐíÊÇ×Ö¶ÎÀàÐÍÄĶù³öÁËÎÊÌ⣬²éÁ˺þã¬ÊÔÁ˺ü¸´Î£¬»¹ÊDz»ÐУ¬ºóÀ´Í»È»»ÐÈ»´óÎò£¬order byÊÇÅÅÐòÓï¾ä£¬order¿Ï¶¨ÊDZ£Áô×Ö£¬Ôõô¿ÉÄÜ×ö±íÃûÄØ¡£¡£¡£Á¢¼´°Ñ±í ......

PHP³ÌÐòºÍMySqlÊý¾ÝÂÒÂëÎÊÌâÔ­Òò¼°½â¾ö

PHP³ÌÐòºÍMySqlÊý¾ÝÂÒÂëÎÊÌâÔ­Òò¼°½â¾ö
ÂÒÂëÎÊÌâ¼òµ¥Ëµ¾ÍÊÇÊý¾Ý¿âдÈë¶ÁÈ¡£¬ÍøÒ³Îļþ£¬ÍøÒ³ÏÔʾʱ¼¸¸ö»·½ÚµÄ±àÂë²»Ò»ÖÂÔì³ÉµÄ¡£
ÂÒÂëÎÊÌâ
дÈëʱ£ºÒ³ÃæÌáȡдÈëÊý¾Ý±àÂëºÍдÈëÊý¾Ý¿âʱ±àÂë²»Ò»ÖÂ
¶Áȡʱ£º¶ÁÈ¡ºóËùÓñàÂëÓëÊý¾Ý¿âдÈëʱ²»Ò»ÖÂ
ÏÔʾʱ£º±àÂëÓëÊý¾Ý¿â¶ÁÈ¡ºóµÄÊý¾Ý²»Ò»ÖÂ
ºÜÏÔȻֻÓÐÈýÕß¶¼Í³Ò»²ÅÐУ ......

½â¾ömysql¿Í»§¶ËÂÒÂë

ͨ³£ÎÒϰ¹ß½«mysqlÊý¾Ý¿âÉèÖÃĬÈϱàÂëΪutf-8£¬Õâ¾ÍÓÐÒ»¸öÎÊÌ⣬ÔÚwindows¿Í»§¶ËÖÐÖÐÎÄÏÔʾÂÒÂ룬ÒòΪwindowsĬÈϱàÂëΪgb2312»òansi¡£¶à·½²éÕÒÖÕÓÚ½â¾ö£¬ÔÚwindows¿Í»§¶ËµÇÈëmysql
ÊäÈë
set NAMES GB2312;
СÃüÁ´ó×÷Óð¡¡£ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ