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

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

1.ÏÂÔØ MySQL 6.0Ãâ°²×°°æ
http://dev.mysql.com/get/Downloads/MySQL-6.0/mysql-noinstall-6.0.9-alpha-win32.zip/from/pick#mirrors
2.½« MySQL6.0 ½âѹµ½´ý°²×°Ä¿Â¼(×Ô¼º¾ö¶¨·Åµ½ÄÄ£©¡£½âѹºóĬÈÏÎļþ¼ÐÃû³ÆÎª£ºmysql-6.0.9-alpha-win32£¨µ±È»¿ÉÒÔ×Ô¼º¸ü¸Ä£©£¬È»ºóÔÚ»·¾³±äÁ¿ÖÐÉèÖÃMYSQL_HOME£¨ÕâÑù£¬ÒÔºó¿ÉÒÔÓÃ%MYSQL_HOME%ÒýÓð²×°Ä¿Â¼£©¡£È磬ÎÒ·ÅÔÚEÅ̸ùĿ¼Ï£¬ËùÒÔ£¬MYSQL_HOMEÉèÖÃΪ£ºE:\mysql-6.0.9-alpha-win32
3.´ò¿ªÎļþmy-huge.iniÁí´æÎªmy.ini£¬ÔÚmy.iniÎļþ×îºó£¨µ±È»Ò²¿ÉÒÔÔÚÆäËûµØ·½£©¼ÓÈëÈçÏÂÅäÖá£(my.ini¼ÇµÃÊDZ£´æÔÚÓëmy-huge.iniͬһ¸öĿ¼Ïµģ©(#±íʾעÊÍ£©
[mysqld]
# ÉèÖÃmysqlµÄ°²×°Ä¿Â¼
basedir=E:\mysql-6.0.9-alpha-win32
# ÉèÖÃmysqlÊý¾Ý¿âµÄÊý¾ÝµÄ´æ·ÅĿ¼£¬±ØÐëÊÇdata£¬»òÕßÊÇ[url=file://\\xxx-data]\\xxx-data[/url]
datadir=E:\mysql-6.0.9-alpha-win32\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Ëæ»úÊý¾ÝÉú³É²¢²åÈë

      dblpÊý¾Ý¿âÖÐÒýÓÃÐÅÏ¢ºÜÉÙ£¬Æ½¾ùһƪÂÛÎÄÒýÓÃ0.2ƪ¡£Ê¹ÓÃdblp×öʵÑéÊý¾Ý¼¯µÄijƪÂÛÎÄÌáµ½£¬¿ÉÒÔËæ»úÌí¼ÓÒýÓÃÐÅÏ¢¡£ÊÜ´ËÆô·¢£¬ÎÒ´òËãΪÿһƪÂÛÎͼÌí¼Ó20ÆªËæ»úÒýÓã¬ÓÚÊǾÍд³öÁËÈçϵÄsqlÓï¾ä£º
     String sql = "insert into citation(pId1,pId2) values( (selec ......

LVS & MySQL NDB Cluster

×é³ÉLVS×îÖØÒªµÄ²¿·ÖÓÐÈý¸ö£ºÇëÇó·Ö·¢·þÎñÆ÷¡¢´¦Àí·þÎñÆ÷¡¢¹²Ïí´æ´¢¡£
µäÐ͵ÄWeb¼¯Èº²¢²»ÐèÒª¹²Ïí´æ´¢£¬Ö»ÓÐÇëÇó·Ö·¢·þÎñÆ÷ºÍ´¦Àí·þÎñÆ÷£¬ÈçÏÂͼËùʾ£º
Èç¹ûÍê³ÉÇëÇóÐèÒª»ùÓÚÊý¾Ý£¬ÄÇô¹²Ïí´æ´¢¾ÍÊÇLVS±ØÐëµÄ×é¼þÁË¡£LVSÓʼþ·þÎñÆ÷¼¯ÈºÈçÏÂËùʾ£º
ĿǰÄÜÓ¦ÓÃÓÚLVSµÄMySQL¼¯ÈºÖ»ÄÜÊÇNDB Cluster£¬ÒòΪMySQLÖÚ¶àµÄ´æ´¢ÒýÇæ ......

Ò»¸öMYSQLµÄСÎÊÌâ

Ò»ÏÂÊÇÒ»¸öSQLµÄСÎÊÌ⣬À§ÈÅÁË3·ÖÖÓ£¬Ð´ÏÂÀ´¼Ç¼һÏ¡£
Êý¾Ý¿âÊÇMYSQL 5, ±íµÄ½á¹¹ºÜ¼òµ¥, ¾ÍÒ»¸ö×Ö¶ÎÊÇabc£¬ÕûÐÍ¡£
Ò»ÏÂÓï¾äÔËÐеĽá¹ûÊÇÒ»ÑùµÄ¡£×Ô¼º²»ÁôÉñ£¬µ¼ÖÂÀ§ÈÅÁË3·ÖÖÓ¡£
select * from table1 from abc = '123'
select * from table1 from abc = '123_1'
ÒÔÉÏÓï¾äÔ­À´ÊDzéÕÒÊÇ·ñÊý¾Ý´æÔÚ£¬½á¹û123_1ºÍ1 ......

MYSQLʵÏÖ¶Áд·ÖÀë


LUA°æ±¾£ºlua-5.1.4.tar.gz
MySql_proxy°æ±¾£ºmysql-proxy-0.6.1-linux-rhel4-x86-32bit.tar.gz
 
´úÀí»ú£ºLinuxºìñ £¨222.31.76.229£©
Êý¾Ý¿â·þÎñÆ÷£ºAÖ÷£º£¨222.31.76.99£©£¬B´Ó£º£¨222.31.76.102£©
 
AºÍB°²×°Mysql
5.1   £»
´úÀí»ú°²×°LUA£¬MYSQL_PROXY£»
1¡¢ LUAµÄ°²×°
[root@localh ......

ÍüÁËOracleµÄsysÓû§ºÍMySQLµÄrootÓû§ÃÜÂ룬½â¾ö·½·¨

ÍüÁËOracleµÄsysÓû§ºÍMySQLµÄrootÓû§ÃÜÂ룬½â¾ö·½·¨
2007Äê03ÔÂ16ÈÕ ÐÇÆÚÎå 09:44
×÷Õߣºhexiong¡¡
°æÈ¨ÉùÃ÷£º¿ÉÒÔÈÎÒâ×ªÔØ£¬×ªÔØÊ±ÇëÎñ±ØÒÔ³¬Á´½ÓÐÎʽ±êÃ÷ÎÄÕÂԭʼ³ö´¦ºÍ×÷ÕßÐÅÏ¢¼°±¾ÉùÃ÷¡£
http://hi.baidu.com/hexiong/blog/item/b4acd72a85272d2cd42af1b1.html
¾­³£Åöµ½ÓÐÈËÔÚÂÛ̳ÉÏÎÊÕâ¸öÎÊÌ⣬¸É´àÔÚÕâÀï×ܽáÒ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ