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ÁË¡£
Ïà¹ØÎĵµ£º
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Öг£ÓõÄÐ޸ıíµÄÃüÁî
¹Ø¼ü×Ö: mysql, Ð޸ıí, ÃüÁî
ÔÚÊý¾Ý¿â²Ù×÷ÖÐ,¸öÈ˾õµÃʹÓõÃ×î¶àµÄ¾ÍÊDzéѯ,È»ºó¾ÍÊǶԱíµÄÐ޸IJÙ×÷ÁË,ÓÈÆäÊǵ±Êý¾Ý¿âµÄÉè¼Æ¹¤×÷ûÓÐ×öºÃʱ.ÏÂÃæ¾ÍMySQLÖÐһЩ³£ÓõÄÐ޸ıíµÄ²Ù×÷½øÐÐ×ܽá:
ΪÁË·½±ãºóÃæµÄ˵Ã÷,ÏÈ´´½¨Ò»¸ö±í,´´½¨Óï¾äÈçÏÂ:
Create ......
Blogϵͳ×÷Ϊ´ó¼Ò×î³£½Ó´¥µÄ»¥ÁªÍø¶«¶«£¬ÔÚÕ¾³¤ÈºÌåÖм¸ºõÈËÊÖÒ»²©£¬´ÓÖªÃûÃÅ»§µÄ²©¿ÍƵµÀ£¬µ½ÍøÂçÓªÏúר¼Ò²©¿Í£¬ÍøÃñ¶Ô²©¿ÍµÄ¹Ø×¢¶ÈÔÚ²»¶ÏÌá¸ß²¢É¡£Ä¿Ç°ÍøÉÏÃâ·ÑµÄblogϵͳ̫ÔÓ£¬ÔÚ´ËÕûÀíPHP°æµÄBlog½éÉÜÈçÏ£º
1¡¢wordpress:http://www.wordpress.org ¹¦ÄÜÒ²ºÜÈ«Ã棬Ӧ¸ÃÊÇÖ§³ÖblogµÄÊ×Ñ¡¡£ËüÓÐ×îÇ¿µÄÄ£°æ¹¦ÄÜ£¬ÒѾ ......
ÒÔǰû½Ó´¥¹ýÕâ¸ö¶«¶«£¬Ç°ÌìÒ»¸öͬÊÂÈÃÎÒ°²×°ÏÂ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 ÊÇ·ñ³ ......