ubuntu ÏÂ MYSQL °²×°
°²×°MySQL
sudo apt-get install mysql-server mysql-admin mysql-navigator mysql-query-browser
Õâ¸öÓ¦¸ÃºÜ¼òµ¥ÁË£¬¶øÇÒÎÒ¾õµÃ´ó¼ÒÔÚ°²×°·½ÃæҲûʲô̫´óÎÊÌ⣬ËùÒÔÒ²¾Í²»¶à˵ÁË£¬ÏÂÃæÎÒÃÇÀ´½²½²ÅäÖá£
ÅäÖÃMySQL
×¢Ò⣬ÔÚUbuntuÏÂMySQLȱʡÊÇÖ»ÔÊÐí±¾µØ·ÃÎʵģ¬Èç¹ûÄãÒªÆäËû»úÆ÷Ò²Äܹ»·ÃÎʵĻ°£¬ÄÇôÐèÒª¸Ä±ä/etc/mysql/my.cnfÅäÖÃÎļþÁË£¡ÏÂÃæÎÒÃÇÒ»²½²½µØÀ´£º
ĬÈϵÄMySQL°²×°Ö®ºó¸ùÓû§ÊÇûÓÐÃÜÂëµÄ£¬ËùÒÔÊ×ÏÈÓøùÓû§½øÈ룺
$mysql -u root
ÔÚÕâÀïÖ®ËùÒÔÓÃ-u rootÊÇÒòΪÎÒÏÖÔÚÊÇÒ»°ãÓû§£¨firehare£©£¬Èç¹û²»¼Ó-u
rootµÄ»°£¬mysql»áÒÔΪÊÇfirehareÔڵǼ¡£×¢Ò⣬ÎÒÔÚÕâÀïûÓнøÈë¸ùÓû§Ä£Ê½£¬ÒòΪû±ØÒª¡£Ò»°ãÀ´Ëµ£¬¶ÔmysqlÖеÄÊý¾Ý¿â½øÐвÙ×÷£¬
¸ù±¾Ã»±ØÒª½øÈë¸ùÓû§Ä£Ê½£¬Ö»ÓÐÔÚÉèÖÃʱ²ÅÓÐÕâÖÖ¿ÉÄÜ¡£
½øÈëmysqlÖ®ºó£¬×îÒª½ôµÄ¾ÍÊÇÒªÉèÖÃMysqlÖеÄrootÓû§ÃÜÂëÁË£¬·ñÔò£¬Mysql·þÎñÎÞ°²È«¿ÉÑÔÁË¡£
mysql> GRANT ALL PRIVILEGES ON *.* TO root@localhost IDENTIFIED BY "123456";
×¢Ò⣬ÎÒÕâ¶ùÓõÄÊÇ123456×öΪrootÓû§µÄÃÜÂ룬µ«ÊǸÃÃÜÂëÊDz»°²È«µÄ£¬Çë´ó¼Ò×îºÃʹÓôóСд×ÖĸÓëÊý×Ö»ìºÏµÄÃÜÂ룬ÇÒ²»ÉÙÓÚ8λ¡£
ÕâÑùµÄ»°£¬¾ÍÉèÖúÃÁËMySQLÖеÄrootÓû§ÃÜÂëÁË£¬È»ºó¾ÍÓÃrootÓû§½¨Á¢ÄãËùÐèÒªµÄÊý¾Ý¿â¡£ÎÒÕâÀï¾ÍÒÔxoopsΪÀý£º
mysql>CREATE DATABASE xoops£»
mysql>GRANT ALL PRIVILEGES ON xoops.* TO xoops_root@localhost IDENTIFIED BY "654321";
ÕâÑù¾Í½¨Á¢ÁËÒ»¸öxoops_rootsµÄÓû§£¬Ëü¶ÔÊý¾Ý¿âxoopsÓÐ×ÅÈ«²¿È¨ÏÞ¡£ÒÔºó¾ÍÓÃxoops_rootÀ´¶ÔxoopsÊý¾Ý¿â½øÐйÜÀí£¬¶øÎÞÐèÒªÔÙÓÃrootÓû§ÁË£¬¶ø¸ÃÓû§µÄȨÏÞÒ²Ö»±»ÏÞ¶¨ÔÚxoopsÊý¾Ý¿âÖС£
Èç¹ûÄãÏë½øÐÐÔ¶³Ì·ÃÎÊ»ò¿ØÖÆ£¬ÄÇôÄãÒª×öÁ½¼þÊ£º
ÆäÒ»£º
mysql>GRANT ALL PRIVILEGES ON xoops.* TO xoops_root@"%" IDENTIFIED BY "654321";
ÔÊÐíxoops_rootÓû§¿ÉÒÔ´ÓÈÎÒâ»úÆ÷ÉϵÇÈëMySQL¡£
Æä¶þ£º
$sudo gedit /etc/mysql/my.cnf
Àϵİ汾ÖÐ
>skip-networking => # skip-networking
еİ汾ÖÐ
>bind-address=127.0.0.1 => bind-address= Äã»úÆ÷µÄIP
ÕâÑù¾Í¿ÉÒÔÔÊÐíÆäËû»úÆ÷·ÃÎÊMySQLÁË¡£
Ïà¹ØÎĵµ£º
½ñÌ죬ҪÓÃexplain²é¿´mysqlµÄÖ´Ðй滮£¬µ«ÊǺÍPostgreSQL²»Í¬µÄÊÇ£¬Ö±½ÓÔÚmysqlÀïÃæÖ´ÐеĽá¹û¿É¶ÁÐÔ²»ÊǺܺã¬ÉÏÍøËÑÁËһȦ£¬·¢ÏÖÁËÒ»¸ö¹¤¾ßmaatkit£¬¿ÉÒÔ½²explainµÄ½á¹ûת»¯ÎªÊ÷×´½á¹¹²é¿´£¬ºÇºÇ£¬·½±ãÁ˺ܶà
°²×°°ì·¨£º
1. sudo yum install mysql
2. sudo yum install mysql-server
3. wget http://maatkit.googl ......
Ç°Ì᣺MySQLÖдæÔÚÒ»¸öÓû§×Ô¼º½¨Á¢µÄÊý¾Ý¿â£¬¼ÙÉèΪmydb£¬mydbÖÐÓÐÒ»ÕÅÓû§×Ô¼º½¨Á¢µÄ±í¸ñ£¬¼ÙÉèÃû³ÆΪmytable
ÎÒµÄÇ°Ì᣺MySQLÖдæÔÚÁ½¸öÊý¾Ý¿â£¬yldbºÍyldb2£¬ÆäÖÐyldbÊý¾Ý¿âÖÐÓÐÒ»ÕÅ±í£¬ÃûΪpet
Ò».MYSQLµÄÃüÁîÐÐģʽµÄÉèÖãº
×ÀÃæ->ÎҵĵçÄÔ->ÊôÐÔ->»·¾³±äÁ¿->н¨->
PATH=“£»path\mysql\bin ......
ÒÔǰû½Ó´¥¹ýÕâ¸ö¶«¶«£¬Ç°ÌìÒ»¸öͬÊÂÈÃÎÒ°²×°ÏÂjira+confluence£¬µ«ÊÇconfluenceŪÁ˺ó¤Ê±¼äҲû¼¯³É³É¹¦£¡ÏÖÔÚ°ÑÉÏÊöÈýÕߵļ¯³É¹ý³Ì×ܽáÏ£¡
°²×°»·¾³£º
ϵͳ£ºxp sp2
jdk: 1.6
tomcat: 5.5 °²×°°æ (¿ÉÒÔÓýâѹ°æµÄ)
MySql: 5.0.x
ËùÐèÈí¼þ£º
jiar£º atlassian-jira-enterprise-3.9.3.zi ......
×î½üÓöµ½Ò»¸öÐèÇóÒªÔÚlinuxÏÂÓÃjava µ÷ÓÃmysql¿Í»§¶ËÔ¶³ÌµÇ½mysql·þÎñÆ÷£¬´Ó¿Í»§¶Ë»úÆ÷µ¼Èëmysql½Å±¾£¬´Ómysql·þÎñÆ÷¶Ëµ¼³ö±íÖеÄÊý¾Ý¡£ÒÔÏÂÊÇÓõ½µÄÖ÷Òª·½·¨£º
Java ´úÂë
/**
* µ¼ÈëÊý¾Ý
* @param ½Å±¾µÄµØÖ·ºÍÃû³Æ
* @return ÊÇ·ñ³ ......