XAMPP 1.7.0ÖÐMySqlÎÞ·¨Æô¶¯½â¾ö·½·¨
ÎÒÔÚ°²×°XAMPP 1.7.0ʱ£¬°²×°³É¹¦ºó£¬´òËãÆô¶¯XAMPP¡£Apache˳ÀûÆô¶¯£¬µ«ÊÇMySqlÔõô¶¼Æô¶¯²»ÁË£¬ÌáʾµÄ´íÎóÊÇ£º
error:mysql service not started [-1]
ÎÒÖØÐÂ×°Á˼¸´Î¶¼²»ÐУ¬ÏÂÔØÁËÆäËûµÄ°æ±¾Ò²²»ÐУ¬ÎÒÕæ¸ã²»Çå³þΪʲô¡£ÎÒGoogleÁ˰ëÌ죬ÆðÏÈʱÖÐÎÄÍøÒ³£¬°´ÕÕ¼¸¸ö½â¾ö·½·¨×öÁ˶¼²»ÐУ¬¿Ï¶¨ÊÇûÓжÔÖ¢ÏÂÒ©°Ñ£¬È»ºóÎÒµ½Google.com in English
ÖÕÓÚÕÒµ½Á˽â¾ö·½·¨£º
ÔËÐÐxampp\mysql Ŀ¼Ï嵀 mysql_installservice.bat
µ¯³ödos´°¿Úºó°´ÈÎÒâ¼ü¹Ø±Õ£¬È»ºóÔËÐÐÏàͬĿ¼Ï嵀 mysql_uninstallservice.bat
¼´¿É£¬ÔÚXAMPPµÄ¿ØÖưæÃæ¿ÉÒԳɹ¦Æô¶¯ MySqlÀ²£¬¹þ¹þ¡£(Special thanks to Wiedmann
)
ÕâÎÊÌâÌ«¹ý¹Å¹Ö£¬ÓôÃÆÖС£
µ±È»£¬ÒªÈ·±£XAMPPÄÜÕý³£¹¤×÷£¬¶Ë¿Ú 80 ºÍ443£¬3306±ØÐë¿ÕÏС£Ã»¿ÕÏеϰ¿ÉÒÔÓö˿ڼàÌý¹¤¾ß²é£¬È»ºó½áÊøÏàÓ¦½ø³Ì¡£»òÕßÔÚcmd
ÊäÈënetstat
-ano£¬¿´Õ⼸¸ö¶Ë¿ÚÊÇ·ñÕ¼Óã¬ÈôÕ¼Ó㬼ÇסPID£¬È»ºóÔÚÈÎÎñ¹ÜÀíÆ÷Àï¶ÔÓÚÏàÓ¦µÄPID£¬½áÊø¼´¿É¡£Ã»PIDÏÔʾµÄ»°µã»÷ÈÎÎñ¹ÜÀíÆ÷µÄ²é¿´£¬È»ºóµãÑ¡
ÔñÁУ¬¹´Ñ¡PID¼´¿É¡£
Ïà¹ØÎĵµ£º
1.CREATE USER
CREATE USER user [IDENTIFIED BY [PASSWORD] 'password']
[, user [IDENTIFIED BY [PASSWORD] 'password']] ...
CREATE USERÓÃÓÚ´´½¨ÐµÄMySQLÕË»§¡£ÒªÊ¹ÓÃCREATE USER£¬Äú±ØÐëÓµÓÐmysqlÊý¾Ý¿âµÄÈ«¾ÖCREATE USERȨÏÞ£¬»òÓµÓÐINSERTȨÏÞ¡£¶ÔÓÚÿ¸öÕË»§£¬CREATE USER»áÔÚûÓÐȨÏÞµÄmysq ......
from:http://www.ccvita.com/100.html
mysql 5.0´æ´¢¹ý³Ìѧϰ×ܽá
Ò».´´½¨´æ´¢¹ý³Ì
1.»ù±¾Óï·¨£º
create procedure sp_name()
begin
………
end
2.²ÎÊý´«µÝ
¶þ.µ÷Óô洢¹ý³Ì
1.»ù±¾Óï·¨£ºcall sp_name()
×¢Ò⣺´æ´¢¹ý³ÌÃû³ÆºóÃæ±ØÐë¼ÓÀ¨ºÅ£¬ÄÄŸô洢¹ý³ÌûÓвÎÊý´«µÝ
Èý.ɾ³ý´æ´¢¹ý³Ì
1 ......
´úÂëÈçÏ£º
1 String command = " cmd /c C:/Program Files/MySQL/MySQL Server 5.0/bin>mysqldump -h localhost -u root -p aijia > E:/aijia.dmp " ;
2 try {
3 Process process& ......
10055:ûÓлº´æ¿Õ¼ä¿ÉÀûÓà ·½·¨:²é¿´ÏÂÄãµÄCÅ̿ռäÊÇ·ñÒѾÂú,Çå³ýһЩûÓÐÓõÄÎļþ. ¿ÉÒÔÔÚºǫ́µÄ"ÂÛ̳ºËÐÄÉèÖÃ","ºËÐŦÄÜÉèÖÃ"Àï"½ø³ÌÓÅ»¯"¿ªÆô,"GZIP ѹËõÊä³ö"¹Ø±Õ. ²éÕÒÁËÒ»ÏÂ10055£¨Ã»Óлº´æ
˵Ã÷:Èç¹ûÓöµ½Êý¾Ý¿â³ö´íµÄÎÊÌâÐÞ¸ÄÏàÓ¦µÄ´úÂëºóÒ»°ãÒªÖØÆômysql¡£Èç¹ûÓöµ½mysqlµÄÎÊÌâ¿ÉÒÔÏÈÖØÆ ......
×î½ü¹¤×÷Éϳ£Óõ½MySQL£¬·¢ÏÖMySQLµÄ´íÎóÌáʾÒô±È½Ï·³ÈË£¬ÉÏÍøËÑË÷ÁËһϣ¬ÓÐÒÔÏÂÈýÖֹرոÃÌáʾÒôµÄ·½·¨£º
·½·¨1. ʹÓÃÖÕ¶ËÃüÁî
ʹÓÃMySQLµÄÃüÁîÖÕ¶Ëʱ£¬Ê¹ÓÃmysql --no-beep¼´¿É¡£
·½·¨2. ÐÞ¸ÄMySQLÅäÖÃÎļþmy.ini
ÔÚ[mysql] ϼÓÈëÒ»ÐÐ
no-beep
&nb ......