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

½â¾öÈçºÎÐÞ¸Ämysql·þÎñÆ÷¼àÌý¶Ë¿ÚµÄÎÊÌâ

 1£©Èç¹ûÄã°²×°µÄÊÇϵͳ×Ô´øµÄrpm°üµÄÇé¿ö£º
ÐÞ¸Ä /etc/my.cnf
[mysqld]
datadir=/var/lib/mysql
port=3300                    #Ð޸ijÉÄã×Ô¼ºÏëÒªµÄ¶Ë¿Ú
socket=/var/lib/mysql/mysql.sock
[mysql.server]
user=mysql
basedir=/var/lib
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
±£´æÍ˳ö¡£
2£©Èç¹ûÄã°²×°µÄÊÇÆäËûÔ´Âë°ü»òÕßÔÚͬһ·þÎñÆ÷Éϰ²×°¶à¸ömysqld·þÎñµÄÇé¿ö£º
ͬÑùµÄÅäÖã¬ÕÒ³ömy.cnf Îļþ¡£Ìí¼Óport= ¶Ë¿ÚºÅ
ÐèҪעÒâµÄÊÇ
[client]
port            = 3300
ÕâÀïÒ²Òª¸Äһϡ£


Ïà¹ØÎĵµ£º

CʵÏÖMySQLÊý¾Ý¿â²Ù×÷

       Á½¸öÔÂǰ£¬Ò²¾ÍÊÇ9Ô·ݣ¬ÐÄѪÀ´³±ÔÚwindowsÏÂʵÏÖÁËÓÃCÁ¬½ÓÊý¾Ý¿â£¬µ±Ê±ºÜÊÇÓаÑlinuxÏÂÒ»²¢¸øÊµÏÖÁË¡£µ«ÊÇûÓÐÏëµÃÄÇô¼òµ¥¡£Õâ¸öÈÎÎñÒ»Ö±ÍÆ³Ùµ½ÁËÏÖÔÚ²ÅÍê³É£¬¾¿ÆäÔ­Òò£º1.ÎÒÖ±½ÓÓÃeclipse¿ª·¢¹¤¾ß£¬¶ÔÓÚ»·¾³±äÁ¿µÄÉèÖò»ÊǺÜÊì¡£2.linuxϵͳ¿âÎļþ½á¹¹²»ÊìϤ£¬¶ÔÓÚmysqlÌṩµÄ¿âÎļþûÓÐ·Å¶Ô ......

mysqlÔ¶³ÌȨÏÞÉèÖÃ

 1¡¢½øÈëmysql£¬´´½¨Ò»¸öÐÂÓû§xuys£º
¸ñʽ£ºgrant ȨÏÞ on Êý¾Ý¿âÃû.±íÃû Óû§@µÇ¼Ö÷»ú identified by "Óû§ÃÜÂë";
grant select,update,insert,delete on *.* to xuys@192.168.88.234 identified by "xuys1234";
   ²é¿´½á¹û£¬Ö´ÐУº
   use mysql;
   select host,user,p ......

¿ÉÁ¯µÄSun¹«Ë¾£¬ÒòΪÊÕ¹ºÁËMySQL£¬ÏëÂô×Ô¼º¶¼Âô²»ÁËÁË

write by ¾ÅÌìÑãôá(JTianLing) -- blog.csdn.net/vagrxie ÌÖÂÛÐÂÎÅ×é¼°Îļþ ½ñÌì¿´µ½CSDNÉϵÄÒ»ÔòÐÂÎÅ¡¶Å·ÃËÕýʽ·ñ¾ö¼×¹ÇÎÄÊÕ¹ºSun ¼×¹ÇÎľÝÀíÁ¦Õù¡·ºóÕæÊǸÐ̾°¡¡£¡£¡£¡£ SunÒ²ËãÊÇÊ¢¼«Ò»Ê±µÄ´ó¹«Ë¾ÁË£¬ÒòΪJAVAÓïÑÔ¶øÎÅÃûÓÚÊÀ£¬ºóÀ´¹ÉƱ´úÂë¶¼¸Ä³ÉJAVAÁË£¬ËäÈ»JAVAʵ¼ÊÉÏûÓÐΪÆä´øÀ´Ì«¶àµÄÀûÈ󣬵«ÊÇSunÒ²ËãÊÇÄܹ»×Ô¼ ......

ͨ¹ý·ÖÇø£¨Partition£©ÌáÉýMySQLÐÔÄÜ

°³½ñÌìÕâô¼¤¶¯ÓÖÏëдÎÄÕµÄÔ­ÒòÊÇMySQL5.1µÄ·¢²¼´øÀ´ÁËÉè¼Æ³¬Ç¿¶¯Á¦Êý¾Ý¿âµÄÇ¿ÓÐÁ¦µÄÎäÆ÷£¬ÈκÎMySQLµÄDBA¶¼Ó¦¸Ã¾¡¿ìѧϰ²¢Ê¹ÓÃËü¡£°³¾õµÃÈç¹ûÄܺܺõÎʹÓÃÕâ¸ö5.1°æ´øÀ´µÄÐÂÌØÐÔ£¬DBA¿ÉÒÔʹ×Ô¼º¹ÜÀíµÄVLDB£¨²»ÖªµÀʲôÊÇVLDB£¿¸æËßÄ㣬ÊǺôóºÃ´óµÄÊý¾Ý¿âµÄÒâ˼£¬Very Large DB£©»òÊý¾Ý²Ö¿âÆæ¼£°ãµÄ»ñµÃ¾Þ´óµÄÐÔÄÜÌáÉý¡£ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ