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¼´¿É¡£
Ïà¹ØÎĵµ£º
ÅäÖû·¾³:UUbuntu 8.04
1.°²×°vsftpd
sudo apt-get install vsftpd
2.´´½¨guestÓû§
vsftpd°²×°µÄʱºò»á×Ô¶¯°²×ªÒ»¸öftpÓû§£¬ÔÚpasswdÖÐɾ³ý
sudo useradd virtual
ÉèÖÃvirtualµÄÃÜÂëΪwebftp
sudo passwd virtual
±à¼virtualÓû§µÄÖ÷Ŀ¼²¢ÉèÖÃshell
sudo vim /etc/passwd
ÎÒÉèÖõÄÊÇvirtual:x:1001: ......
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 ......
²Ù×÷Êý¾Ý¿â
µÇ¼µ½mysqlÖУ¬È»ºóÔÚmysqlµÄÌáʾ·ûÏÂÔËÐÐÏÂÁÐÃüÁÿ¸öÃüÁîÒԷֺŽáÊø¡£
1¡¢ ÏÔʾÊý¾Ý¿âÁÐ±í¡£
show databases;
ȱʡÓÐÁ½¸öÊý¾Ý¿â£ºmysqlºÍtest¡£ mysql¿â´æ·Å×ÅmysqlµÄϵͳºÍÓû§È¨ÏÞÐÅÏ¢£¬ÎÒÃǸÄÃÜÂëºÍÐÂÔöÓû§£¬Êµ¼ÊÉϾÍÊǶÔÕâ¸ö¿â½øÐвÙ×÷¡£
2¡¢ ÏÔʾ¿âÖе ......
ÒÔǰû½Ó´¥¹ýÕâ¸ö¶«¶«£¬Ç°ÌìÒ»¸öͬÊÂÈÃÎÒ°²×°ÏÂjira+confluence£¬µ«ÊÇconfluenceŪÁ˺ó¤Ê±¼äҲû¼¯³É³É¹¦£¡ÏÖÔÚ°ÑÉÏÊöÈýÕߵļ¯³É¹ý³Ì×ܽáÏ£¡
°²×°»·¾³£º
ϵͳ£ºxp sp2
jdk: 1.6
tomcat: 5.5 °²×°°æ (¿ÉÒÔÓýâѹ°æµÄ)
MySql: 5.0.x
ËùÐèÈí¼þ£º
jiar£º atlassian-jira-enterprise-3.9.3.zi ......
http://www.javaeye.com/topic/211951
Õâ¶Îʱ¼äÔÚ¿´¡¶High Performance MySQL¡·£¬¿´µ½´æ´¢ÒýÇæÕâ¸öµØ·½¸Ðµ½ºÜ¶àϸ½Ú±È½ÏÄ°Éú£¬ËùÒÔ×ܽáС¼ÇһЩ
ΪÁËÊÊÓ¦¸÷ÖÖ²»Í¬µÄÔËÐл·¾³£¬MYSQLÌṩÁ˶àÖÖ²»Í¬µÄ´æ´¢ÒýÇ棨Storage Engine £©,ÔÚÓ¦ÓóÌÐò¿ª·¢Õâ¸ö²ãÃæÉÏ£¬¿ª·¢Õß¿ÉÒÔ¸ù¾Ý²»Í¬µÄÐèÇóÑ¡ÔñÊʺϵÄStorage Engine ·½°¸£¬¸üΪÁ ......