ubuntuÖÐmysqlÂÒÂëÎÊÌâ
ÏÈ¿´ÏÂÃæ×¢ÒâÄÚÈÝ
ÕûÕûŪÁËÒ»Ì죬ÖÕÓÚ½â¾öÁËjdbc(mysql-connector-java-5.0.30)ºÍmysqͨÐÅÖÐÎÄÂÒÂëµÄÎÊÌ⣡ÎÒµÄϵͳÊÇ
linux£¨ubuntu£©¡£ÔÚjavaÖУ¨Myeclipse»·¾³£©Ê¹ÓÃhibernateÁ¬½Ómysql¡£´æ´¢Ó¢ÎÄûÎÊÌ⣬д£¨insert
into£©ºÍ¶Á£¨select£©¶¼ÄÜÕýÈ·ÏÔʾ£¬µ«ÊÇÈôÆäÖдøÓÐÖÐÎÄ×Ö·û¾Í³ÉÂÒÂëÁË¡£µ½ÍøÉϲéÕÒÁË°ëÌì×ÊÁÏ£¬×îºó
ÖÕÓڳɹ¦¡£
ÎҵĽâ¾ö·½·¨ÊÇ£¬ÔÚ/etc/my.cnfÎļþÖмÓÉÏÒÔÏÂÁ½ÐÐÄÚÈÝ£º
[client]default-character-set=utf8[mysqld]default-character-set=utf8
×¢Ò⣬Õâ¸öÎļþ²»Ò»¶¨´æÔÚ£¬Ð轫 /°²×°ÔÎļþ/support-files/my-medium.cnf ¸´ÖƵ½/etc/Ï£¬ÖØÃüÃû
ÐèÖØÆômysql
Í£Óãºsudo /usr/local/mysql/bin/mysqladmin shutdown
ÆôÓÃsudo /usr/local/mysql/bin/mysqld_safe -user=mysql &
²é¿´mysql±àÂë
ÆôÓúósudo /usr/local/mysql/bin/mysql
mysql>show variables like 'character%';
-------------------------- ----------------------------
| Variable_name | Value |
-------------------------- ----------------------------
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
-------------------------- ----------------------------
×¢Ò⣬ÕâÑù¸Ä±äºóÔÏÈËù½¨Êý¾Ý¿âËƺõ²»ÄÜÓ㨲»È·¶¨£©£¬¾¡Á¿±¸·Ý
н¨Êý¾Ý¿â£¬¾Í²»»áÓÐÂÒÂëÁË¡£
screen.width*0.7)
{this.resized=true; this.width=screen.width*0.7; this.alt='Click here
to open new window\nCTRL Mouse wheel to zoom in/out';}"
onmouseover="if(this.width>screen.width*0.7) {this.resized=true;
this.width=screen.width*0.7; this.style.cursor='hand'; this.alt='Click
here to open new window\nCTRL Mouse wheel to zoom in/out';}"
onclick="if(!this.resiz
Ïà¹ØÎĵµ£º
½ñÌìÔÚÊý¾Ý¿âÖвåÈëÁËÖÐÎÄ£¬·¢ÏÖÓеÄÊÇÂÒÂ룬ÓеIJ»ÊÇ£¬ºÜÊÇÄÉÃÆ¡£
×îºóÕÒµ½Á˽â¾ö°ì·¨£º
´ò¿ª /etc/mysql/my.cnf
ÔÚ£Ûmysqld]ºÍ£Ûclient]½ÚÏ·ֱðÌí¼Ó:
default-character-set = utf8
È»ºóÖØÐÂÆô¶¯mysql£¬ÐèҪעÒâµÄÊÇ£¬¶ÔÐÞ¸ÄÒÔÇ°´´½¨µÄÊý¾Ý¿âÀ´Ëµ£¬ËûµÄ×Ö·û¼¯»¹ÊÇÔÀ´µÄ£¬ËùÒÔ»¹ÊÇ»á³öÏÖÂÒÂí£¬¶øд´½¨µÄÊý¾Ý ......
mysql Êý¾Ý¿âĬÈϵÄÁ¬½ÓÖ»ÄÜÔÚ±¾»úÁ¬½Ó£¬Ô¶³ÌÁ¬½Ó±ØÐëÊÚȨ¡£
´úÂë: È«Ñ¡
¡¡GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'%'IDENTIFIED
BY 'mypassword' WITH GRANT
OPTION;Èç¹ûÄãÏëÔÊÐíÓû§myuser´ÓipΪ192.168.1.6µÄÖ÷»úÁ¬½Óµ½mysql·þÎñÆ÷£¬²¢Ê¹ÓÃ
mypassword×÷ΪÃÜÂë
´úÂë: GRANT ALL PR ......
groupadd mysql
н¨Ò»¸öÃûΪmysqlµÄÓû§×é
useradd -g mysql mysql
ÔÚmysqlÓû§×éÏÂн¨Ò»¸öÃûΪmysqlµÄÓû§
gunzip ½âѹÏÂÔص½µÄ.gzÎļþ
cd mysql-VERSION
½øÈë½âѹºóµÄĿ¼
CFLAGS="-O3 -mcpu=pentium4" CXX=gcc CXXFLAGS="-O3 -march=pentium4 -felide-constructors -fno-exceptions -fno-rtti" ./configu ......
mysql°²×°Í¼½â½Ì³Ì 5.1
2009Äê03ÔÂ01ÈÕ ÐÇÆÚÈÕ 23:51
תÔØÇë×¢Ã÷³ö´¦:http://hi.baidu.com/herdff/blog/item/6e6b4bcf6132f90b93457e14.html
±¾½Ì³ÌÒÔMysql 5.1°æ±¾ÎªÀý£¬¸ü¸ß°æ±¾°²×°¹ý³ÌÓë´ËÀàËÆ¡£ÔĶÁÇ°£¬ÇëÏÂÔØ5.1£¬ÏÂÔصØÖ·£ºwww.mysql.com
°²×°¹ý³ÌÓëÆäËüWindows°²×°³ÌÐòÒ»Ñù£¬Ê×ÏȳöÏÖµÄÊÇ°²×°Ïòµ¼»¶Ó½çÃæ
Ö ......
´¥·¢³ÌÐòÊÇÓë±íÓйصÄÃüÃûÊý¾Ý¿â¶ÔÏ󣬵±±íÉϳöÏÖÌض¨Ê¼þʱ£¬½«¼¤»î¸Ã¶ÔÏó¡£ÔÚijЩ´¥·¢³ÌÐòµÄÓ÷¨ÖУ¬¿ÉÓÃÓÚ¼ì²é²åÈëµ½±íÖеÄÖµ£¬»ò¶Ô¸üÐÂÉæ¼°µÄÖµ½øÐмÆËã¡£
´¥·¢³ÌÐòÓë±íÏà¹Ø£¬µ±¶Ô±íÖ´ÐÐINSERT¡¢DELETE»òUPDATEÓï¾äʱ£¬½«¼¤»î´¥·¢³ÌÐò¡£¿ÉÒÔ½«´¥·¢³ÌÐòÉèÖÃΪÔÚÖ´ÐÐÓï¾ä֮ǰ»òÖ®ºó¼¤»î¡£ÀýÈ磬¿ÉÒÔÔÚ´Ó±íÖÐɾ³ýÿһÐÐÖ® ......