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ΪÎÒÃÇÌṩÁ˺ܶà±íÀàÐ͹©Ñ¡Ôñ£¬ÓÐMyISAM¡¢ISAM¡¢HEAP¡¢BerkeleyDB¡¢InnoDB£¬MERGE±íÀàÐÍÿһÖÖ±íÀàÐͶ¼ÓÐÆä×Ô¼ºµÄÊôÐÔºÍÓŵ㡣ÏÂÃæÎÒÃÇÀ´¼òµ¥µÄÌÖÂÛһϡ£
MyISAM±íÀàÐÍ£º
MyISAM
±í(TYPE=MYISAM)ÊÇISAMÀàÐ͵ÄÒ»ÖÖÑÓÉ죬¾ßÓкܶàÓÅ»¯ºÍÔöÇ¿µÄÌØÐÔ¡£ÊÇMySQLµÄĬÈϱíÀàÐÍ¡£MyISAMÓÅ»¯ÁËѹËõ±ÈÀýºÍËٶȣ¬²¢ÇÒ
¿ÉÒ& ......
1¡¢ÏÔʾÊý¾Ý¿âÁÐ±í£º
show databases;
¸Õ¿ªÊ¼Ê±²ÅÁ½¸öÊý¾Ý¿â£ºmysqlºÍtest¡£mysql¿âºÜÖØÒªËüÀïÃæÓÐMYSQLµÄϵͳÐÅÏ¢£¬ÎÒÃǸÄÃÜÂëºÍÐÂÔöÓû§£¬Êµ¼ÊÉϾÍÊÇÓÃÕâ¸ö¿â½øÐвÙ×÷¡£
2¡¢ÏÔʾ¿âÖеÄÊý¾Ý±í£º
use mysql£» //´ò¿ª¿â
show tables;
3¡¢ÏÔʾÊý¾Ý±íµÄ½á¹¹£ ......
MySQLÓкܶà¿ÉÒÔµ¼ÈëÊý¾ÝµÄ·½·¨£¬È»¶øÕâЩֻÊÇÊý¾Ý´«ÊäÖеÄÒ»°ë£¬ÁíÍâµÄÒ»°ãÊÇ´ÓMySQLÊý¾Ý¿âÖе¼³öÊý¾Ý¡£ÓÐÐí¶àµÄÔÒòÎÒÃÇÐèÒªµ¼³öÊý¾Ý¡£Ò»¸öÖØÒªµÄÔÒòÊÇÓÃÓÚ±¸·ÝÊý¾Ý¿â¡£Êý¾ÝµÄÔì¼Û³£³£ÊÇ°º¹óµÄ£¬ÐèÒª½÷É÷´¦ÀíËüÃÇ¡£¾³£µØ±¸·Ý¿ÉÒÔ°ïÖú·ÀÖ¹±¦¹óÊý¾ÝµØ¶ªÊ§£»ÁíÍâÒ»¸öÔÒòÊÇ£¬Ò²ÐíÄúÏ£Íûµ¼³öÊý¾ÝÀ´¹²Ïí¡£ ÔÚÕâ¸öÐÅÏ¢¼¼Êõ²»¶ ......
֮ǰװ¹ýÒ»±é MySQL 5.1£¬Í¬ÑùµÄ msi °²×°Îļþ£¬Ð¶ÔØ MySQL Ö®ºó¹ý¼¸ÌìÖØÐÂ×°È´Ôõô¶¼²»ÐС£
°²×°ºÃÁËÖ®ºóÅäÖà MySQL ʵÀýµÄʱºòµ½µÚÈý²½“Start Service”Ôõô¶¼¹ý²»È¥£¬³¢ÊÔ×Ô¼ºÆô¶¯·þÎñ»òÕßÓÃÃüÁîÐÐÆô¶¯£¬¶¼Ê§°Ü£»ÉÏÍøÕÒÁËһϣ¬±ðÈËÒ»°ã¶¼Ëµ my.ini ÓÐÎÊÌ⣬³¢ÊÔÁËÒ²²»¹ÜÓá£
ÔÙ´ÎÖØ×°µÄʱºò£¬ÎÞÒâÖп´¼ûÓÐ ......
1.apacheµÄ°²×°
apache±¾À´ÊÇÏëÓñàÒë°²×°µÄ£¬µ«ÊÇÆädevelÐèÒªÒÀÀµÒ»Ð©ÆäËûµÄ°ü£¬°²×°ÆðÀ´Ì«Âé·³£¬ËùÒÔ¾ö¶¨Ê¹Óñ¾µØyumÔ´°²×°£»ÔÚrhel5u3ÉÏ£¬Ö±½Ó yum install httpd
yum install httpd-devel
ÕâÑù»áÓÐhttpd-develµÄһЩÒÀÀµ°üÒ»²¢°²×°ÁË£»
rpm°²×°µÄhttpdÓÐÈçϼ¸¸öÖØÒªµÄĿ¼£º
1)/etc/ht ......