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

MySQL Ãâ°²×°°æÅäÖÃ

1.ÏÂÔØ MySQL 6.0Ãâ°²×°°æ
http://www.mysql.com/downloads/mirror.php?id=386828
2.½« MySQL6.0 ½âѹµ½´ý°²×°Ä¿Â¼(×Ô¼º¾ö¶¨·Åµ½ÄÄ£©¡£½âѹºóĬÈÏÎļþ¼ÐÃû³ÆÎª£ºmysql£¨µ±È»¿ÉÒÔ×Ô¼º¸ü¸Ä£©£¬È»ºóÔÚ»·¾³±äÁ¿ÖÐÉèÖÃMYSQL_HOME£¨ÕâÑù£¬ÒÔºó¿ÉÒÔÓÃ%MYSQL_HOME%ÒýÓð²×°Ä¿Â¼£©¡£È磬ÎÒ·ÅÔÚEÅ̸ùĿ¼Ï£¬ËùÒÔ£¬MYSQL_HOMEÉèÖÃΪ£ºE:\mysql
3.´ò¿ªÎļþmy-huge.iniÁí´æÎªmy.ini£¬ÔÚmy.iniÎļþ×îºó£¨µ±È»Ò²¿ÉÒÔÔÚÆäËûµØ·½£©¼ÓÈëÈçÏÂÅäÖá£(my.ini¼ÇµÃÊDZ£´æÔÚÓëmy-huge.iniͬһ¸öĿ¼Ïµģ©(#±íʾעÊÍ£©
[mysqld]
# ÉèÖÃmysqlµÄ°²×°Ä¿Â¼
basedir=E:\mysql
# ÉèÖÃmysqlÊý¾Ý¿âµÄÊý¾ÝµÄ´æ·ÅĿ¼£¬±ØÐëÊÇdata£¬»òÕßÊÇ[url=file://\\xxx-data]\\xxx-data[/url]
datadir=E:\mysql\data
4.°Ñ%MYSQL_HOME%\bin ¼ÓÈëµ½ path»·¾³±äÁ¿ÖС£
5.ÔÚÃüÁîÐУ¨cmd£©Ö´ÐÐÃüÁmysqld -install  ¡£½«mysql°²×°Îªwindows·þÎñ¡££¨Ò»¶¨×¢Ò⣬ִÐдËÃüÁîʱһ¶¨ÒªÔÚ°²×°Ä¿Â¼ÏµÄ\binĿ¼ÏÂÖ´ÐС£·ñÔò»á³öÎÊÌâ¡££©
6.Ö´ÐÐÃüÁ net start mysql »òÔÚwindows¹ÜÀí¹¤¾ß->·þÎñÀïÕÒµ½MySQL·þÎñ£¬Æô¶¯¡£
5.ÔÚÃüÁîÐÐÖÐÔËÐÐ mysql -uroot  £¨¿ÉÔÚÈÎÒâĿ¼Ï£¬ÒòÎªÇ°ÃæÉèÖÃÁËpath±äÁ¿£©¡£¼´¿É½øÈëÊý¾Ý¿â¡£
Ò»°ãÇé¿öÏ£¬ÕâÑù²Ù×÷ºó£¬mysql°²×°Íê³É¡£
×¢£º
Èç¹ûÒÔǰϵͳ´æÔÚmysql¡£Ôò½øÈëÒÔǰϵͳ´æÔÚµÄmysqlĿ¼,Ö´ÐÐ mysqld-nt.exe --remove(ÏÈ´ÓϵͳÖÐÒÆ³ýmysql·þÎñ)ÔÚ¿ªÊ¼Ö´ÐÐÉÏÃæµÚ4²½¡£
¡ïÉèÖÃMySQLÖÐÎÄ×Ö·û¼¯£¨MySQLÕý³£ÏÔʾÖÐÎÄ£©
1).ÅäÖ÷þÎñÆ÷¶Ë£¬ÐÞ¸Ämy.iniÎļþ£¬Ê¹ÓÃÖÐÎÄ×Ö·û¼¯´æ´¢¼Ç¼£¬Í¬Ê±ÓÃÖÐÎÄÅÅÐò±È½Ï·½Ê½¡£
[mysqld]
# set character set,ʹÓÃÖÐÎÄ×Ö·û¼¯´æ´¢¼Ç¼
default-character-set=gbk
# set character collation,ʹÓÃÖÐÎÄÅÅÐò±È½Ï·½Ê½
default-collation=gbk_chinese_ci
2). Èç¹ûÒªÔÚÖÐÎÄ»·¾³µÄ·þÎñÆ÷¶ËʹÓÃmysqlÃüÁîÐУ¬¸Ä±ämy.iniÎļþÖÐmysqlµÄĬÈÏ×Ö·û¼¯¡£
[mysql]
# set character set
default-character-set=gbk
¡ïÐÞ¸ÄrootÃÜÂë
MySQLÅäÖÃºÃºó£¬Æô¶¯³É¹¦£¬Ä¬ÈÏÃÜÂëÊǿգ¬µ«ÊÇΪÁ˰²È«£¬ÉèÖÃÃÜÂ루MySQLÓÐÒ»¸öĬÈÏÓû§ÃûΪroot£¬ÃÜÂë×Ô¼ºÉ趨£º¼ÙÈçÉèΪroot£©¡£
1£©µÇ¼MySQL rootÓû§£º
   ´ò¿ªÃüÁîÐУ¬Ö´ÐУºmysql -uroot
2£©ÐÞ¸ÄrootÃÜÂ룺
       mysql> update mysql.user set password="root" where User=''root'';
       mysql> flush privileg


Ïà¹ØÎĵµ£º

ubuntu MySQL°²×°Ö¸ÄÏ

Òª°²×° MySQL£¬¿ÉÒÔÔÚÖÕ¶ËÌáʾ·ûºóÔËÐÐÏÂÁÐÃüÁ
sudo apt-get install mysql-server
sudo apt-get install mysql-client
sudo apt-get install php5-mysql
// °²×°php5-mysql Êǽ«phpºÍmysqlÁ¬½ÓÆðÀ´
Ò»µ©°²×°Íê³É£¬MySQL ·þÎñÆ÷Ó¦¸Ã×Ô¶¯Æô¶¯¡£Äú¿ÉÒÔÔÚÖÕ¶ËÌáʾ·ûºóÔËÐÐÒÔÏÂÃüÁîÀ´¼ì²é MySQL ·þÎñÆ÷ÊÇ·ñÕýÔÚÔËÐУº ......

¿ªÆôMYSQLÈÕÖ¾ÅäÖÃ

ÔÚ[mysqld] ÏÂÌí¼Ó²ÎÊýÈçÏÂ
 #´íÎóÈÕÖ¾Êä³ö·¾¶(ʹÓÃ/×÷Ϊ·Ö¸î¶ø²»ÊÇ\)
log-error="your error-log path"
log="Your mysql log path"
log-show-queries="Your slowquery path"
#É趨³¬Ê±Ê±¼ä ´Ë´¦ÉèÖÃΪÁ½Ãë
long_query_time=2
Ok save my.ini
next
#Í£Ö¹mysql ·þÎñ
net s ......

ÔõÑù½â¾ömysqlµÄtoo many connectionsÎÊÌâ?

¿ÉÒԲο¼ÏÂÁÐÎÄÕÂ
http://www.mysqlperformanceblog.com/2010/03/23/too-many-connections-no-problem/
½áÂÛÈçÏ£º
£¨1£©mysqlĬÈÏ»á¸øsuperÓû§ÁôÒ»¸öÁ¬½Ó£¬Äã¿ÉÒÔÓÃÕâ¸öÔ¤ÁôµÄÁ¬½ÓÀ´µÇ¼£¬À´Ôö¼ÓÁ¬½ÓÊý£»µ«ÊÇÈç¹ûÁ¬½ÓµÄÓû§È«ÊÇsuperȨÏ޵ģ¬ÔòÕâ¸öÔ¤ÁôµÄÁ¬½Ó²»´æÔÚ¡£Õâʱ¿ÉÒÔÓÃÒÔϵÄÃüÁîÀ´ÉèÖÃÁ¬½ÓÊý£ºgdb -p $(cat ......

MysqlÖÐÎÊ×Ö·ûÏÖʵÂÒÂëºÍÎÞ·¨Ìí¼ÓÖÐÎÄÊý¾ÝÎÊÌâ

      ½ñÌìÖÕÓÚÕÒµ½×Ô¼ºµ÷ÊÔÉÐѧÌÃshoppingÏîĿʱµÄÎÊÌâËùÔÚÁË£¬Í¨¹ý²é×ÊÁÏ£¬¶ÔmyeclipseºÍtomcatµÄ²¿ÊðÓÖÓÐÁ˸üÉîÒ»¸ö²ã´ÎµÄÁ˽⣬³ÌÐòµ÷ͨÁË£¬ÐË·ÜÁËÒ»ÏÂÏ£¬¹þ¹þ¡£¡£
      È¥ºǫ́Ìí¼ÓÊý¾Ý·¢ÏÖ´ÓmysqlÖжÁ³öµÄÖÐÎÄÈ«²¿ÏÖʵΪ¿É°®µÄÎʺţ¬ÕâϺÃÁË£¬ÎÒÐÄÀïÒ²²úÉúÎʺŠ......

ʹÓÃhibernateÓëmysqlʱÊý¾Ý²»ÄܲåÈëµÄÔ­Òò¼°½â¾ö°ì·¨

1.±³¾°     
      Ö®Ç°´ÓûÓùýhibernate£¬Òò´ËÔÚÍøÉÏËÑÁËÒ»ÏÂhibernate¿ìËÙÈëÃÅ·½ÃæµÄÐÅÏ¢£¬×îºóÎÒ°´ÕÕ¡¶Myeclipse Hibernate ¿ìËÙÈëÃÅ ÖÐÎİ桷£¨CSDN£¬°Ù¶ÈÎĿⶼÓУ©Ò»ÎÄ¿ªÊ¼ÁËÎÒµÄhibernateÖ®Âã¨ÎªÏîÄ¿×ö¼¼Êõ×¼±¸£©¡£
      ÏÂÃ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ