winÏÂApache mysql PHPÅäÖÃ
1¡¢HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Services\Eventlog\Application\MySQL
Ŀ¼ɾ³ý
2¡¢HKEY_LOCAL_MACHINE\SYSTEM\ControlSet003\Services\Eventlog\Application\MySQL
Ŀ¼ɾ³ý
3¡¢HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog\Application\MySQL
Ŀ¼ɾ³ý
Ïà¹ØÎĵµ£º
ΪʲôѡÔñÔ´Âë±àÒë°²×°mysql£ºÎÒÔÚʹÓÃrpm»òÕßÊÇyum°²×°Ê±myql£¬ÀÏÊÇÌáʾÎÒÕÒ²»µ½*.sockÎļþ£¬ÕÒÁ˵ã
×ÊÁÏ˵ÊǸðüÊǷǹٷ½°æ±¾£¨Ã÷Ã÷Êǹٷ½ÏÂÔØ µÄ£©£¬ÆäÖÐÔÒòµ½ÏÖÔÚ»¹Ã»ÓиãÇå³þ¡£Ï£ÍûÖªÇéÈËÊ¿¸æÖª¡££¨¿ªÊ¼±àÒëµÄʱºò£¬ÏµÍ³»·¾³Ò»¶¨ÒªÅäÖúã¬GCC£¬GC++...µÈµÈµÄ±àÒëÆ÷Ò»¶¨Òª×öºÃ,±¾È˵ÄcentosÓÉÓÚ¿ªÊ¼
ϵͳ»·¾³Ã»ÅäÖ ......
ÔÚmysqlÊÖ²áÀïÃæÓÐÒ»¶ÎÃèÊö¹ØÓÚlock tablesµÄÓï·¨µÄ. LOCK TABLES
tbl_name [AS alias] {READ [LOCAL] | [LOW_PRIORITY] WRITE}
[, tbl_name [AS alias] {READ [LOCAL] | [LOW_PRIORITY] WRITE}] ...
UNLOCK TABLES
READ
µ±±í²»´æÔÚ WRITE Ð´ËøÊ± READ ¶ÁËø±»Ö´ÐÐ,Õâ¸Ã ......
MYSQLÖг£ÓõÄÃüÁî´óÈ«
Ò»¡¢ Êý¾Ý¿â²Ù×÷µÄÃüÁî
1. ´´½¨Êý¾Ý¿â
Ø create database Name;
2. Ñ¡ÔñÊý¾Ý¿â
Ø use DatabaseName;
3. Ö±½Óɾ³ýÊý¾Ý¿â£¬²»ÌáÐÑ
Ø drop database Name;
4. ɾ³ýÊý¾Ý¿âǰ£¬ÓÐÌáʾ¡£
Ø drop ......
Ê×ÏÈ£¬´ò¿ªcmd—–net start ²é¿´mysqlÊÇ·ñÆô¶¯¡£Æô¶¯µÄ»°¾ÍÍ£Ö¹net stop mysql.
1¡¢ÔÚdosÏÂÔËÐÐC:\Program Files\MySQL\MySQL Server 5.0\bin
2¡¢mysqld-nt --init-file=c:\mysql\pwdhf.txt ÆäÖÐÔÚc:\mysql½¨Ò»¸öpwdhf.txtÎļþ£¬²¢Ð´ÏÂÄãµÄÐÂÃÜÂë¡£
3¡¢ÔËÐÐЩÃüÁîºó£¬ÔÙÓÃÐÂÃÜÂëµÇ¼£¬¼´¿É³É¹¦ÐÞ¸ÄÃÜÂë¡£ ......
SQL²éѯ»º´æ
Êʺ϶ÁÕß
±¾½Ì³ÌÊʺÏÓÚÄÇЩ¶Ô»º´æSQL²éѯÒÔ¼õÉÙÊý¾Ý¿âÁ¬½ÓÓëÖ´ÐеĸºÔØ¡¢Ìá¸ß½Å±¾ÐÔÄܸÐÐËȤµÄPHP³ÌÐòÔ±¡£
¸ÅÊö
Ðí¶àÕ¾µãʹÓÃÊý¾Ý¿â×÷ΪվµãÊý¾Ý´æ´¢µÄÈÝÆ÷¡£Êý¾Ý¿â°üº¬Á˲úÆ÷ÐÅÏ¢¡¢Ä¿Â¼½á¹¹¡¢ÎÄÕ»òÕßÁôÑÔ±¾£¬ÓÐЩÊý¾ÝºÜ¿ÉÄÜÊÇÍêÈ«¾²Ì¬µÄ£¬ÕâЩ½«»á´ÓÒ»¸ö»º´æÏµÍ³Öеõ½µÄ¼«´óºÃ´¦¡£
ÕâÑùÒ»¸öϵͳͨ¹ý°ÑS ......