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

fedora11 Ï mysql Ô´Âë°²×°¹ý³Ì


»·¾³:
  fedora11 , mysql5.1.34Ô´Âë°²×°£º
  
  ×°ÁËÒ»Ìì°ëһֱûÓгɹ¦£¬ºóÀ´·ÅÆúÁË£¬ÒòΪfedora11µÄԴϲ»µ½mysqlËùÒÔÖ»ÄÜ·ÅÆúÔÚfedora11ϵݲװ£¬×ª¶ø¸Äµ½unbuntu9.04Éϰ²×°£¬µ«ÊÇÏëÏëÎÊÌâÊÇûÓÐ
½â¾öµÄ£¬½ñÌìÓÖ×ªÒÆµ½fedoraϸ㣬·¢ÏÖ²»Êǰ²×°mysqlÄÑ£¬ÊÇӦΪ×Ô¼º¶Ôlinuxϵͳ²»ÊìϤ£¬ºÜ¶à¶«Î÷¶¼²»Ã÷°×£¬ËùÒÔûÓÐ×°³É¹¦¡£
  mysqlÔ´Âë°ü°²×°¹ý³Ì²ÉÓÃ./configure make makeinstall
  ÓÉÓÚ°²×°²»ÉÏ£¬ËùÒÔÎÒ²ÉÓÃĬÈÏ·¾¶×°£¬µ£ÐÄÓÖ»á³ö²î´í£¬ÍƼöµÄ°²×°¹ý³ÌÊÇ£º
  $tar xzf mysql-5.1.34.tar.gz¡¾Õâ¸ö¹ý³ÌÊÇÔÚdebianÉϵģ¬ÔÚfedoraºÍubuntu¼°ÆäËülinuxϵͳÉÏÒ²Ò»Ñù¡¿
    $cd mysql-5.1.34/
    $./configure  --enable-local-infile  --with-charset=utf8  --with-extra-charsets=all  --with-plugins=all  --with-big-tables
    $make
    $sudo make install$tar xzf mysql-5.1.34.tar.gz
    $cd mysql-5.1.34/
    $./configure  --enable-local-infile  --with-charset=utf8  --with-extra-charsets=all  --with-plugins=all  --with-big-tables
    $make
    $sudo make install
 µ±°²×°Íê³Éºó£¬½øÈë/usr/local/binÔËÐÐÈçϳÌÐò£º£¨¸Ã³ÌÐòÏÔʾ½á¹ûµÄ˵Ã÷¼ûËùÔÚÐУ©
 [root@localhost bin]# ./mysql_install_db 
Installing MySQL system tables...
OK
Filling help tables...
OK
To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system¡¾×¢ÊÍ£ºÄãÐèÒª½«Ô´Âë°üĿ¼ÏµÄmysql.server¿½±´µ½linuxÆô¶¯Ä¿Â¼Ï£¬¶ÔÓÚfedora11¿½±´µ½µÃĿ¼ÊÇ/etc/init.d/²¢¸ü¸ÄÆäÃû×ÖΪmysqld£¬×¢ÒâÈç¹ûÊǸü¸ÄÁËϵͳĬÈÏ
°²×°Â·¾¶ÐèÒª´ò¿ª¸ÃÎļþ£¬°´ÕÕ¸ÃÎļþÖÐÌáʾµÄÄÚÈÝÐ޸ġ£·ñÔò¿ÉÄܲ»³É¹¦¡£Ö®ºóÐÞ¸ÄȨÏÞ
chmod +x /etc/init.d/mysqld
°²×°½Å±¾ºó£¬ÓÃÀ´¼¤»îËüÒÔ±ãÔÚϵͳÆô¶¯Ê±ÔËÐÐËùÐèÒªµÄÃüÁîÈ¡¾öÓÚÄãµÄ²Ù×÷ϵͳ¡£ÔÚLinuxÖУ¬Äã¿ÉÒÔʹÓÃchkconfig£º
 chkconfig --list mysql
mysql ·þÎñÖ§³Ö chkconfig£¬µ«ËüÔÚÈκμ¶±ðÖж¼Ã»Óб»ÒýÓÃ(ÔËÐГchkconfig --add mysql”)
 chkconfig --a


Ïà¹ØÎĵµ£º

mysqlÂÒÂëÎÊÌâ

´´½¨µÄһЩ±í»á³öÏÖÕâÑùµÄÎÊÌ⣺ӢÎIJåÈëµ½±íÖÐûÓÐÈκÎÎÊÌâ¡£µ«ÊDzåÈëÖÐÎĵÄʱºò¾Í³öÏÖ Data truncation: Data too long for column 'name' at row 1 ÀàËÆµÄÎÊÌâ¡£
mysqlÄܰÑÓ¢ÎÄ×ֶβåÈçÊý¾Ý¿âÁË¡¡µ±ÎÒÊäÈëÖÐÎÄʱËû¾Í³öÏÖ×Ö¶ÎData truncation: Data too long for column 'name' at row 1
ÎÒʹÓÃÅóÓѵÄÕâ¸ö·½·¨£º(1)ÐÞ¸ ......

MySQL ·þÎñÎÞ·¨Æô¶¯ 1067 ´íÎó ½ø³ÌÒâÍâÖÕÖ¹½â¾ö·½·¨

֮ǰװ¹ýÒ»±é MySQL 5.1£¬Í¬ÑùµÄ msi °²×°Îļþ£¬Ð¶ÔØ MySQL Ö®ºó¹ý¼¸ÌìÖØÐÂ×°È´Ôõô¶¼²»ÐС£
°²×°ºÃÁËÖ®ºóÅäÖà MySQL ʵÀýµÄʱºòµ½µÚÈý²½“Start Service”Ôõô¶¼¹ý²»È¥£¬³¢ÊÔ×Ô¼ºÆô¶¯·þÎñ»òÕßÓÃÃüÁîÐÐÆô¶¯£¬¶¼Ê§°Ü£»ÉÏÍøÕÒÁËһϣ¬±ðÈËÒ»°ã¶¼Ëµ my.ini ÓÐÎÊÌ⣬³¢ÊÔÁËÒ²²»¹ÜÓá£
ÔÙ´Î֨װµÄʱºò£¬ÎÞÒâÖп´¼ûÓÐ ......

¹ØÓÚMySQL±íÉè¼ÆÓ¦¸Ã×¢ÒâµÄÎÊÌâ(×öÁ˵ãÐÞ¸Ä)


¹ØÓÚMySQL±íÉè¼ÆÓ¦¸Ã×¢ÒâµÄÎÊÌâ(×öÁ˵ãÐÞ¸Ä)  
  
¹Ø
ÓÚÉè¼Æ±íʱӦ¸Ã×¢ÒâµÄÎÊÌâ  
  
ÈçÓдíÎó»¶Ó­´ó¼ÒÖ¸³ö¡£Õâ
¶Îʱ¼äÔÚ¼ÒÀ×öÁ˵ãÐÞÕý¡£  
  
1
¡¢É÷ÖØÑ¡Ôñ±íÃû¡£  
  
ÓÐ
Á½ÖÖÑ¡Ôñ£º  
  
°´ÕÕ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ