Windowsƽ̨¶àMYSQLÅäÖÃ(¶àMy.ini)
×î½üÔÚѧϰSSH£¬ÓÉÓÚΪÁ˽ÚÔ¼Äڴ棬ËùÒÔ¾Í×¼±¸Ê¹ÓÃMYSQL´úÌæOracle£¬ÎªÁ˸üÉîÒ»²½µØÁ˽âMySQL£¬ÓÚÊǾͼƻ®°²×°noinstall°æ±¾£¬Õâ°æ±¾±È°²×°°æ¿ÉÂ鷳һЩ£¬ÌرðÊÇÅäÖ÷½Ã棬Èç¹ûÅäÖúõϰ¾Í¿ÉÒÔÔÚһ̨»úÆ÷ÉÏÔËÐжà¸ö°æ±¾µÄMYSQL£¬ÔÚÍøÉÏÕÒÁËǰ±²ÃǵıʼǺóѧϰÍê±ÏºóÔټǼһ±Ê£¬¾ÍÎÒÕâ¼ÇÐÔ£¬¹À¼ÆÃ÷¶ùÔçÉϾÍÈ«Íü¹âÁË¡£
Ò»¸öƽ̨²¿Êð¶à¸öµÄÇé¿öÏÂ×î»ù±¾µÄ¾ÍÊÇÒª¸øÃ¿¸öƽָ̨¶¨²»Í¬µÄ my.ini Îļþ£¬µ±È»£¬ÔÚ ini ÎļþÖеÄÊý¾Ý¿âµÄ¶Ë¿ÚºÅÒ²»áÓв»Í¬£¬my.ini ÎļþµÄÄÚÈݾͰ´ÕÕ¸÷¸ö°æ±¾µÄ»ù±¾ÅäÖþͿÉÒÔ£¬²»ÐÐËæ±ãÕÒÒ»¸ö¸´ÖƹýÀ´¸Ä¸Ä¾ÍOKÁË£¬Ö÷ÒªÒªÐ޸ĵĵط½ÓÐÕâô¼¸¸ö£º1¡¢basedir = ¡ºµ±È»Òª×¢²áµÄ±¾°æµÄ¸ùĿ¼¡»2¡¢datadir = ¡ºÊý¾ÝĿ¼(dataÎļþ¼ÐλÖÃ)¡»3¡¢port = ¡º¶Ë¿ÚºÅ¡»¶à¸ö±ðÖØ¸´¾ÍÐÐÁË¡£Ö÷Òª¾ÍÊÇÕâ3¸öÖµµÄµØÖ·£¬ÒªÖ¸ÏòÄ㵱ǰÅäÖõÄmysql£¬µ±È»ÆäËûµÄÊôÐÔÒ²Ò»Ñù¡£
È»ºó¾ÍÊǰ²×°³É·þÎñ£¬Èç¹û²»°²×°³É·þÎñ£¬Ã¿´Î¶¼×Ô¼ºÆô¶¯Ò²Ò»Ñù£¬¼Óµã²ÎÊý¾Í¿ÉÒÔÁË¡£
²»°²×°³É·þÎñµÄÆô¶¯·½Ê½ÊÇ£ºbin>mysqld-nt --defaults-file="D:\xxx\old\mysql\my.ini" ÕâÑùÆô¶¯¾ÍÊÇÓÃÖ¸¶¨µÄini È¥Æô¶¯nt·þÎñ¡£
°²×°³É·þÎñ£º °²×°·þÎñÏà¶Ô¼òµ¥£¬X:\XXX\bin>mysqld-nt --install MySQLXXX --defaults-file="X:\XXX\my.ini"Ö»ÒªÔÚbinĿ¼ÏÂÔÚCMDÖÐʹÓà --installÃüÁָ¶¨·þÎñÃû³Æ£¬È»ºó×Ô¶¨Ä¬ÈϵÄiniÎļþÃû¼´¿É¡£ ³õʼ»¯Êý¾Ý¿â£º Ôڷǰ²×°°æÖÐÐèҪʹÓà mysqld-nt --console ³õʼ»¯Êý¾Ý¿â£¬ÔÚ¶àMYSQLÖУ¬°²×°µÚ¶þ¸öMYSQLʱҲÐèÒªÖ¸¶¨Ä¬ÈϵÄiniλÖã¬ÃüÁîΪX:\XXX\bin>mysqld-nt --defaults-file="X:\XXX\my.ini" --console ÕâÑù¾Í¿ÉÒÔÍê³É³õʼ»¯ÁË£¬ÆäËûµÄ²Ù×÷¶¼»ù±¾Ò»ÑùÁË¡£
ÔÚ¿ØÖÆÌ¨ÖÐÆô¶¯mysqlʱÐèÒª¼ÓÉϲÎÊý--port=#Ö®ÃûÐèÒªÖ¸¶¨µÄ¶Ë¿ÚºÅ ¡£
Ïà¹ØÎĵµ£º
Scale Out£ººáÏòÀ©Õ¹£¬Ôö¼Ó´¦Àí½ÚµãÌá¸ßÕûÌå´¦ÀíÄÜÁ¦
Scale Up£º×ÝÏòÀ©Õ¹£¬Í¨¹ýÌáÉýµ¥¸ö½ÚµãµÄ´¦ÀíÄÜÁ¦´ïµ½ÌáÉýÕûÌå´¦ÀíÄÜÁ¦µÄÄ¿µÄ
Replication
MySQLµÄreplicationÊÇÒì²½µÄ£¬ÊÊÓÃÓÚ¶ÔÊý¾ÝʵʱÐÔÒªÇó²»ÊÇÌØ±ð¹Ø¼üµÄ³¡¾°¡£slave¶ËµÄIOÏ̸߳ºÔð´Ómaster¶ÁÈ¡ÈÕÖ¾£¬SQLÏß ³ÌרߺÔðÔÚslave¶ËÓ¦ÓôÓmaster¶Á¹ýÀ´µÄÈÕÖ¾£¨ÔçÆÚ ......
×öÊý¾Ý¿âµ÷ÓÅ£¬Ò»¸ö¼òµ¥µÄtip¾ÍʹÐÔÄÜÌáÉýÒ»´ó¿éʱ£¬±»°ïÖúµÄÈË×ÔÈ»ÊǸßÐ˶øÇҸм¤£¬ÎÒÒ²ÊÇÂúÐÄ»¶Ï²¡£ÓÃËùѧ°ïÖúÁËËûÈË£¬Ò²ËµÃ÷»¹ÊÇÓÐÒ»¼¼Ö®³¤µÄ£¬ÓÐÒ»ÃÅÄܹ»Ñø»î×Ô¼ºµÄÊÖÒÕ¡£Ò²ËãÊÇÊÖÒÕÈ˰¡¡£
ͬÊÂÈÃÎÒ°ïÖúÓÅ»¯£¬ÔÚslow query logÀï·¢ÏÖÓÐÁ½¸öSQLÖ´ÐеĴÎÊý×î¶à£¬²¢ÇÒÿ´Î¶¼ÔÚÁ½ÃëÒÔÉÏ¡£ÓÃexplain¿´ÁË£¬Ò²Î´·¢ÏÖË÷ÒýʹÓ÷ ......
°²×°Íêphpmyadmin
´ó¼Ò¾³£³öÏÖµÄÎÊÌâ¾ÍÊDZ¨´í£º“ÎÞ·¨ÔØÈëmysqlÀ©Õ¹£¬Çë¼ì²éphpÅäÖÔ¡£
Èç¹ûÄãʹÓõÄÊÇphp5.2ÒÔÉϵİ汾£¬Çë×¢Ò⣺php¶Ô·þÎñµÄÀ©Õ¹¹¦ÄÜ×öÁËÒ»¶¨µÄ¸Ä¶¯£¬Ò²¾ÍÊÇ˵£¬Äã°²×°phpºÍÀ©Õ¹µÄ·½Ê½Ò²Òª×öµ÷ÕûÁË¡£
Ö÷ÒªµÄµ÷ÕûÓÐÁ½·½Ã棬һÊÇPHP5.2ÒÔÉϵİ汾ÖУ¬PHP.INIÎļþÎÞÐèÌí¼Óµ½WINDOWSĿ¼Ï¡£¶þ ......
Unix&Linux£º
1.ÓÃroot»òÕßÔËÐÐmysqldµÄÓû§µÇ¼ϵͳ£»
2£®ÀûÓÃkillÃüÁî½áÊøµômysqldµÄ½ø³Ì£»
3£®Ê¹ÓÃ--skip-grant-tables²ÎÊýÆô¶¯MySQL Server
shell>mysqld_safe --skip-grant-tables &
4.Ϊroot@localhostÉèÖÃÐÂÃÜÂë
shell>mysqladmin -u root flush-privileges password "newpassword" ......
Author: Ivan@mysqlab.net/Ì·¿¡Çà ×ªÔØÇë×¢Ã÷À´Ô´URIÁ´½Ó:
http://www.mysqlab.net/blog/2009/04/mysql-54µÄÐÂÌØÐÔ½âÎö/
MySQL 5.4 Ö®ËùÒÔÃüÃûΪ5.4£¬¶ø²»ÊÇ5.2 ÊÇÒòΪ֮ǰµÄ5.2°æ±¾±»ÃüÃûΪ6.0ÁË£¨Õâ¸öÓ¦¸ÃÊÇÉÌÒµÉϵÄÔÒò£¬¾ÍÏñjava1.6±»ÃüÃûΪ6.0£©¡£ÏÖÔÚµÄ5.4 preview release ÊÇÔÚµ±Ç°MySQL5.1µÄ»ù´¡ÉÏ£¬¶Ô Innodb ½ø ......