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
Ïà¹ØÎĵµ£º
´´½¨µÄһЩ±í»á³öÏÖÕâÑùµÄÎÊÌ⣺ӢÎ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 5.1£¬Í¬ÑùµÄ msi °²×°Îļþ£¬Ð¶ÔØ MySQL Ö®ºó¹ý¼¸ÌìÖØÐÂ×°È´Ôõô¶¼²»ÐС£
°²×°ºÃÁËÖ®ºóÅäÖà MySQL ʵÀýµÄʱºòµ½µÚÈý²½“Start Service”Ôõô¶¼¹ý²»È¥£¬³¢ÊÔ×Ô¼ºÆô¶¯·þÎñ»òÕßÓÃÃüÁîÐÐÆô¶¯£¬¶¼Ê§°Ü£»ÉÏÍøÕÒÁËһϣ¬±ðÈËÒ»°ã¶¼Ëµ my.ini ÓÐÎÊÌ⣬³¢ÊÔÁËÒ²²»¹ÜÓá£
ÔÙ´Î֨װµÄʱºò£¬ÎÞÒâÖп´¼ûÓÐ ......
¹ØÓÚMySQL±íÉè¼ÆÓ¦¸Ã×¢ÒâµÄÎÊÌâ(×öÁ˵ãÐÞ¸Ä)
¹Ø
ÓÚÉè¼Æ±íʱӦ¸Ã×¢ÒâµÄÎÊÌâ
ÈçÓдíÎó»¶Ó´ó¼ÒÖ¸³ö¡£Õâ
¶Îʱ¼äÔÚ¼ÒÀ×öÁ˵ãÐÞÕý¡£
1
¡¢É÷ÖØÑ¡Ôñ±íÃû¡£
ÓÐ
Á½ÖÖÑ¡Ôñ£º
°´ÕÕ ......