ÈçºÎÐÞ¸Ämysql rootÃÜÂë
1¡¢±à¼MySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ)ÅäÖÃÎļþ£º
windows»·¾³ÖУº%MySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ)_installdir%\my.ini¡¡//Ò»°ãÔÚMySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ)°²×°Ä¿Â¼ÏÂÓÐmy.ini¼´MySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ)µÄÅäÖÃÎļþ¡£
linux»·¾³ÖУº/etc/my.cnf
ÔÚ[MySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ)d]ÅäÖöÎÌí¼ÓÈçÏÂÒ»ÐУº
skip-grant-tables
±£´æÍ˳ö±à¼¡£
2¡¢È»ºóÖØÆôMySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ)·þÎñ
windows»·¾³ÖУº
net stop MySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ)
net start MySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ)
linux»·¾³ÖУº
/etc/init.d/MySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ)d restart
3¡¢ÉèÖÃеÄROOTÃÜÂë
È»ºóÔÙÔÚÃüÁîÐÐÏÂÖ´ÐУº
MySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ) -uroot -p MySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ)
Ö±½Ó»Ø³µÎÞÐèÃÜÂë¼´¿É½øÈëÊý¾Ý¿âÁË¡£
ÏÖÔÚÎÒÃÇÖ´ÐÐÈçÏÂÓï¾ä°ÑrootÃÜÂë¸üÐÂΪ 7758521£º
update user set password=PASSWORD("7758521") where user='root';
quit Í˳öMySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ)¡£
4¡¢»¹ÔÅäÖÃÎļþ²¢ÖØÆô·þÎñ
È»ºóÐÞ¸ÄMySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ)ÅäÖÃÎļþ°Ñ¸Õ²ÅÌí¼ÓµÄÄÇÒ»ÐÐɾ³ý¡£
ÔÙ´ÎÖØÆðMySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ)·þÎñ£¬ÃÜÂëÐÞ¸ÄÍê±Ï¡£
ÐÞ¸ÄÍê±Ï¡£
ÓÃÐÂÃÜÂë7758521ÊÔһϰɣ¬ÓÖÄܵÇÈëMySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ)µÄ¸Ð¾õ¾ÍÊDz»Ò»Ñù°É£¿
Ïà¹ØÎĵµ£º
query_cache_min_res_unit ²éѯ»º´æ·ÖÅäµÄ×îС¿éµÄ´óС(×Ö½Ú)
query_alloc_block_size Ϊ²éѯ·ÖÎöºÍÖ´Ðйý³ÌÖд´½¨µÄ¶ÔÏó·ÖÅäµÄÄÚ´æ¿é´óС
Qcache_free_blocks´ú±íÄÚ´æ×ÔÓÉ¿éµÄ¶àÉÙ£¬·´Ó³ÁËÄÚ´æË鯬µÄÇé¿ö
==========================
1£©µ±²éѯ½øÐеÄʱºò£¬Mysql°Ñ²éѯ½á¹û±£´æÔÚqurey ......
1.ʹÓÃINSERT²åÈë¶àÌõ¼Ç¼
¿´µ½Õâ¸ö±êÌâÒ²Ðí´ó¼Ò»áÎÊ£¬ÕâÓÐʲôºÃ˵µÄ£¬µ÷Óöà´ÎINSERTÓï¾ä²»¾Í¿ÉÒÔ²åÈë¶àÌõ¼Ç¼ÁËÂð!µ«Ê¹ÓÃÕâÖÖ·½·¨ÒªÔö¼Ó·þÎñÆ÷µÄ¸ººÉ£¬ÒòΪ£¬
Ö´ÐÐÿһ´ÎSQL·þÎñÆ÷¶¼ÒªÍ¬Ñù¶ÔSQL½øÐзÖÎö¡¢ÓÅ»¯µÈ²Ù×÷¡£ÐÒºÃMySQLÌṩÁËÁíÒ»ÖÖ½â¾ö·½°¸£¬¾ÍÊÇʹÓÃÒ»ÌõINSERTÓï¾äÀ´²åÈë¶àÌõ¼Ç¼¡£Õâ²¢
²»ÊDZê×¼µÄSQL ......
MySQLµÄ×Ö·û¼¯Ö§³Ö(Character Set Support)ÓÐÁ½¸ö·½Ã棺
×Ö·û¼¯(Character set)ºÍÅÅÐò·½Ê½(Collation)¡£
¶ÔÓÚ×Ö·û¼¯µÄÖ§³Öϸ»¯µ½Ëĸö²ã´Î:
·þÎñÆ÷(server)£¬Êý¾Ý¿â(database)£¬Êý¾Ý±í(table)ºÍÁ¬½Ó(connection)¡£
1.MySQLĬÈÏ×Ö·û¼¯
MySQL¶ÔÓÚ×Ö·û¼¯µÄ ......
Õ⼸ÌìѧϰÁË´¥·¢Æ÷µÄÓ÷¨£¬¾õµÃ´¥·¢Æ÷ºÜºÃÓð¡¡£
´¥·¢Æ÷µÄ»ù±¾Óï·¨£º
CREATE TRIGGER <´¥·¢Æ÷Ãû><--
{BEFORE | AFTER}
{ INSERT | UPDATE | DELETE }
ON <±íÃû³Æ>
FOR EACH ROW
<´¥·¢Æ÷SQLÓï¾ä>
¹æÔò£º
1.´¥·¢Æ÷±ØÐëÓÐÃû×Ö£¬×î¶à64¸ö×Ö·û£¬¿ÉÄܺóÃæ»á¸½Óзָô·û.ËüºÍMySQLÖÐÆäËû¶ÔÏóµÄÃüÃû· ......