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

jira+tomcat+mysqlµÄ¼¯³É

ÒÔǰû½Ó´¥¹ýÕâ¸ö¶«¶«£¬Ç°ÌìÒ»¸öͬÊÂÈÃÎÒ°²×°ÏÂjira+confluence£¬µ«ÊÇconfluenceŪÁ˺ó¤Ê±¼äҲû¼¯³É³É¹¦£¡ÏÖÔÚ°ÑÉÏÊöÈýÕߵļ¯³É¹ý³Ì×ܽáÏ£¡
°²×°»·¾³£º
ϵͳ£ºxp sp2 
jdk:  1.6
tomcat: 5.5 °²×°°æ   (¿ÉÒÔÓýâѹ°æµÄ)
MySql: 5.0.x
ËùÐèÈí¼þ£º
jiar£º atlassian-jira-enterprise-3.9.3.zip   £¨ÕâÊǸöWAR/ERAµÄ°²×°°ü,¾ÍÊÇÓû§¿ÉÒÔ¼¯³ÉËü×Ô¼ºµÄweb·þÎñÆ÷£©
µÚÈý·½jar°ü£º jira-jars-tomcat5.zip  
mysql-jdbc-driver£ºÕâ¸öÈ¥ËüµÄ¹Ù·½ÍøվϰÉ
¼¯³ÉjiraÇ°µÄ×¼±¸¹¤×÷£º
1.°²×°mysql£¬½¨Á¢Ò»¸öÃûΪ£ºjiradbµÄÊý¾Ý¿â£¬
2.´´½¨Ò»¸öÓû§ÃûΪjirapub ÃÜÂëΪjiraµÄÓû§£¬¸³ÓèËü²Ù×÷jiradbÊý¾Ý¿âµÄȨÏÞ¼´¿É
ÅäÖãº
1.½âѹjira£¬ÆäÎļþĿ¼ÈçÏ£º

2.ÐÞ¸Äedit-webapp\WEB-INF\classes\Ŀ¼ÏµÄentityengine.xmlÎļþ£¬ÕÒµ½datasource½Ú£¬½«field-type-nameÊôÐԸijÉmysql£¬È»ºó½«schema-name="PUBLIC"ɾ³ý£¬±£´æ£¡
3.etc\ϵÄtomcat-5.5-jira.xmlÎļþ£¬ÕÒµ½Resource
½Ú£¬usernameºÍpassword·Ö±ðΪǰÃæ´´½¨µÄÓû§ÃûºÍÃÜÂë¡£ÐÞ¸ÄdriverClassName½ÚÊôÐÔΪcom.mysql.jdbc.Driver£¬ÐÞ¸ÄurlΪ"jdbc:mysql://your ip:port/jiradb?autoReconnect=true&useUnicode=true&characterEncoding=UTF8"±£´æ£¡
4.µã»÷build.batÎļþ£¬µÈ´ýÔËÐÐÍê³Éºó£¬»á¿´µ½Éú³ÉÁËеÄÎļþ£¬ÆäÎļþ½á¹¹´óÖÂÈçÏ£º


5.×öÍêÕâЩ£¬jiraµÄÅäÖûù±¾¾Í²î²»¶àÁË£¬ÏÖÔÚÎÒÃÇÀ´ÅäÖÃtomcat£¬ÈÃËûÖ§³ÖjiraµÄÔËÐÐ
6.ÆäʵÕâ²½ºÜ¼òµ¥£º¿½±´½âѹjira-jars-tomcat5.zip ÏµÄjarÎļþºÍmysqlµÄjdbcÇý¶¯µ½Tomcat 5.5\common\libϾͿÉÒÔÁË
7.½«dist-tomcat\tomcat-5.5µÄjira.xml¿½±´µ½Tomcat 5.5\conf\Catalina\localhost¾Í¿ÉÒÔÁË¡£
×öÍêÕâЩºó£¬ÎÒÃǾͿÉÒÔÆô¶¯tomcatÁË£¬µ±È»ÒªÈ·±£ÄãµÄmysql·þÎñ¿ªÆôÁËŶ£¡Æô¶¯tomcatºó£¬ÎÒÃÇÔÚÔËÐÐÏÂÊäÈ룺http://locahost:8080/jiraºó¾Í¿ÉÒÔ¿ªÊ¼°²×°jiraÁË£¡
ÍƼöÒ»¸ö²Î¿¼ÍøÖ·£ºhttp://www.blogjava.net/yongbing/archive/2008/03/03/183519.html


Ïà¹ØÎĵµ£º

ͨ¹ýrpm°ü°²×°¡¢ÅäÖü°Ð¶ÔØmysqlµÄÏêϸ¹ý³Ì


¡¡¡¡ÒÔMySQL-server-4.0.14-0.i386.rpmΪÀý£¬·ÅÔÚ/dataĿ¼Ï 
¡¡¡¡cd /data 
¡¡¡¡rpm -ivh MySQL-server-4.0.14-0.i386.rpm 
¡¡¡¡°²×°Íê³ÉºóÔÚ/usr/share/mysqlĿ¼ÖлáÓÐÒ»¸ömysqlµÄÆô¶¯½Å±¾mysql.server¼°Ê¾ÀýÅäÖÃÎļþµÈ(Èçmy-huge.cnf¡¢my-large.cnf¡¢my-medium.cnf) 
¡¡¡¡¿½±´Ò»¸öʾÀýÅäÖÃÎ ......

MySqlÊý¾Ý¿âÖØÉèÃÜÂë

1. ¹ØµôMysql·þÎñ
2.н¨Ò»¸öÎı¾Îļþ£¬ÄÚÈÝÈçÏ£º
UPDATE mysql.user SET Password=PASSWORD('NewPassword') WHERE User='root';
FLUSH PRIVILEGES;
×¢Ò⣺һ¶¨Òª·ÖÁ½ÐÐд£¬"NewPassword"ΪÄãµÄÐÂÃÜÂë
3. ±£´æÎļþ£¬²¢°ÑËü·ÅÔÚCÅ̸ùĿ¼Ï£¬ÎļþÃûΪ"mysql-init.txt"£ºC:\mysql-init.txt
 
4. ´ò¿ªcmd´°¿Ú£¬Êä ......

MysqlÖд´½¨Óû§ÕÊ»§µÄ·½·¨

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 ......

blogÔ´ÂëÕûÀí£ºphp+mysql²©¿Í³ÌÐò25ÖÖ

Blogϵͳ×÷Ϊ´ó¼Ò×î³£½Ó´¥µÄ»¥ÁªÍø¶«¶«£¬ÔÚÕ¾³¤ÈºÌåÖм¸ºõÈËÊÖÒ»²©£¬´ÓÖªÃûÃÅ»§µÄ²©¿ÍƵµÀ£¬µ½ÍøÂçÓªÏúר¼Ò²©¿Í£¬ÍøÃñ¶Ô²©¿ÍµÄ¹Ø×¢¶ÈÔÚ²»¶ÏÌá¸ß²¢É¡£Ä¿Ç°ÍøÉÏÃâ·ÑµÄblogϵͳ̫ÔÓ£¬ÔÚ´ËÕûÀíPHP°æµÄBlog½éÉÜÈçÏ£º
1¡¢wordpress:http://www.wordpress.org ¹¦ÄÜÒ²ºÜÈ«Ã棬Ӧ¸ÃÊÇÖ§³ÖblogµÄÊ×Ñ¡¡£ËüÓÐ×îÇ¿µÄÄ£°æ¹¦ÄÜ£¬ÒѾ­ ......

pucasoft_JDBC_t01_Êý¾Ý¿âmysql²Ù×÷

²Ù×÷Êý¾Ý¿â
 
µÇ¼µ½mysqlÖУ¬È»ºóÔÚmysqlµÄÌáʾ·ûÏÂÔËÐÐÏÂÁÐÃüÁÿ¸öÃüÁîÒԷֺŽáÊø¡£
 
1¡¢ ÏÔʾÊý¾Ý¿âÁÐ±í¡£
 
show databases;
 
ȱʡÓÐÁ½¸öÊý¾Ý¿â£ºmysqlºÍtest¡£ mysql¿â´æ·Å×ÅmysqlµÄϵͳºÍÓû§È¨ÏÞÐÅÏ¢£¬ÎÒÃǸÄÃÜÂëºÍÐÂÔöÓû§£¬Êµ¼ÊÉϾÍÊǶÔÕâ¸ö¿â½øÐвÙ×÷¡£
 
2¡¢ ÏÔʾ¿âÖе ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ