Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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±íÀàÐͼòµ¥¶Ô±È

MySQLΪÎÒÃÇÌṩÁ˺ܶà±íÀàÐ͹©Ñ¡Ôñ£¬ÓÐMyISAM¡¢ISAM¡¢HEAP¡¢BerkeleyDB¡¢InnoDB£¬MERGE±íÀàÐÍÿһÖÖ±íÀàÐͶ¼ÓÐÆä×Ô¼ºµÄÊôÐÔºÍÓŵ㡣ÏÂÃæÎÒÃÇÀ´¼òµ¥µÄÌÖÂÛһϡ£
MyISAM±íÀàÐÍ£º
MyISAM
±í(TYPE=MYISAM)ÊÇISAMÀàÐ͵ÄÒ»ÖÖÑÓÉ죬¾ßÓкܶàÓÅ»¯ºÍÔöÇ¿µÄÌØÐÔ¡£ÊÇMySQLµÄĬÈϱíÀàÐÍ¡£MyISAMÓÅ»¯ÁËѹËõ±ÈÀýºÍËٶȣ¬²¢ÇÒ
¿ÉÒ& ......

MySQL²é¿´ºÍµ¼Èëµ¼³öÃüÁî

1¡¢ÏÔʾÊý¾Ý¿âÁÐ±í£º
   show databases;
   ¸Õ¿ªÊ¼Ê±²ÅÁ½¸öÊý¾Ý¿â£ºmysqlºÍtest¡£mysql¿âºÜÖØÒªËüÀïÃæÓÐMYSQLµÄϵͳÐÅÏ¢£¬ÎÒÃǸÄÃÜÂëºÍÐÂÔöÓû§£¬Êµ¼ÊÉϾÍÊÇÓÃÕâ¸ö¿â½øÐвÙ×÷¡£
2¡¢ÏÔʾ¿âÖеÄÊý¾Ý±í£º
   use mysql£» //´ò¿ª¿â
   show tables;
3¡¢ÏÔʾÊý¾Ý±íµÄ½á¹¹£ ......

MySQLÖеÄmysqldumpÃüÁîʹÓÃÏê½â

MySQLÓкܶà¿ÉÒÔµ¼ÈëÊý¾ÝµÄ·½·¨£¬È»¶øÕâЩֻÊÇÊý¾Ý´«ÊäÖеÄÒ»°ë£¬ÁíÍâµÄÒ»°ãÊÇ´ÓMySQLÊý¾Ý¿âÖе¼³öÊý¾Ý¡£ÓÐÐí¶àµÄÔ­ÒòÎÒÃÇÐèÒªµ¼³öÊý¾Ý¡£Ò»¸öÖØÒªµÄÔ­ÒòÊÇÓÃÓÚ±¸·ÝÊý¾Ý¿â¡£Êý¾ÝµÄÔì¼Û³£³£ÊÇ°º¹óµÄ£¬ÐèÒª½÷É÷´¦ÀíËüÃÇ¡£¾­³£µØ±¸·Ý¿ÉÒÔ°ïÖú·ÀÖ¹±¦¹óÊý¾ÝµØ¶ªÊ§£»ÁíÍâÒ»¸öÔ­ÒòÊÇ£¬Ò²ÐíÄúÏ£Íûµ¼³öÊý¾ÝÀ´¹²Ïí¡£ ÔÚÕâ¸öÐÅÏ¢¼¼Êõ²»¶ ......

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

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

apache mysql php°²×°

1.apacheµÄ°²×°
apache±¾À´ÊÇÏëÓñàÒë°²×°µÄ£¬µ«ÊÇÆädevelÐèÒªÒÀÀµÒ»Ð©ÆäËûµÄ°ü£¬°²×°ÆðÀ´Ì«Âé·³£¬ËùÒÔ¾ö¶¨Ê¹Óñ¾µØyumÔ´°²×°£»ÔÚrhel5u3ÉÏ£¬Ö±½Ó yum install httpd
     yum install httpd-devel
ÕâÑù»áÓÐhttpd-develµÄһЩÒÀÀµ°üÒ»²¢°²×°ÁË£»
rpm°²×°µÄhttpdÓÐÈçϼ¸¸öÖØÒªµÄĿ¼£º
1)/etc/ht ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ