MySQL FOR LINUX
MySQL FOR LINUX
Ïȼì²éϵͳÊÇ·ñ×°ÉÏÁËmysql£¬Èç¹ûÓн«ÆäжÔصô
rpm -qa | grep mysql
×¢ÒâmysqlµÄ´óСд£¬´óСд¶¼ÓпÉÄÜ
rpm -e --nodeps mysql*
Ò»¶¨ÒªÓÃ--nodepsжÔØ£¬²»¼ì²éÒÀÀµÐÔ¹Øϵ¡£
´´½¨Óû§mysql
groupadd mysql
useradd -g mysql mysql
passwd mysql
ÔÚ/usr/localϽ¨Á¢ mysql Îļþ¼Ð
È»ºó½«°²×°ÎļþÉÏ´«µ½·þÎñÆ÷ÉÏ£¬ÕâÀïÓõÄÊÇtar.gzµÄÎļþ£¬Ò²ÓÐrpm°ü¿ÉÒÔÓ㬵«ÊÇrpm°ü²»ÄÜÖ¸¶¨°²×°Ä¿Â¼£¬¹Ê²»²ÉÓÃ
tar zxvf mysql-5.0.45.tar.gz
cd mysql-5.0.45
./configure --prefix=/usr/local/mysql --with-charset=gb2312
Ö¸¶¨°²×°Ä¿Â¼Îª/usr/local/mysql£¬×Ö·û¼¯Îªgb2312
make
make install
°²×°Íê³É
ÖØÆô
cp /usr/local/mysql/share/mysql/mysql.server
/etc/init.d/mysqld
copyÆô¶¯µÄmysqldÎļþ
ÏÂÃæÈ·±£mysqlÓû§ÓÐÏàÓ¦µÄȨÏÞ
chmod 700 /etc/init.d/mysqld
cd /usr/local
chmod 750 mysql -R
chgrp mysql mysql -R
chown mysql mysql/var -R
cd /usr/local/mysql/libexec
cp mysqld mysqld.old
strip mysqld
chkconfig --add mysqld
chkconfig --level 345 mysqld on
service mysqld start
Æô¶¯·þÎñ
/usr/local/mysql/bin/mysqld_safe
¿´¿´mysqlÄÜ·ñÕý³£¹¤×÷
mysql -uroot mysql
»òÕß netstat -atln
¿´¿´ÓÐûÓÐ3306µÄ¶Ë¿Ú´ò¿ª,£¨Èç¹ûmysqld²»ÄÜÆô¶¯,¿´¿´/web/mysql/varϵijö´íÈÕÖ¾,Ò»°ã¶¼ÊÇĿ¼ȨÏÞûÓÐÉèÖúõÄÎÊÌâ £©
¹þ¹þ£¬Ã»ÓÐÎÊÌâ¡£Æô¶¯Õý³£¡£
/usr/local/mysql/bin/mysql_install_db --user=mysql
´´½¨Êý¾Ý¿âmysql£¬Óû§Îªmysql
½ÓÏÂÀ´×ö¸öÁ´½Ó£¬¾õµÃ·½±ãһЩ¡££¨×öÁ´½ÓÇ°È·±£Óû§PATH·¾¶ÀïÓÐsbin£©
ln -s /usr/local/mysql/bin/mysql /sbin/mysql
ln -s /usr/local/mysql/bin/mysqladmin /sbin/mysqladmin
ºÃÁË£¬Ã»ÓÐʲôÎÊÌâ¾ÍÖØÐÂÆô¶¯Ò»Ï¡£
½ÓÏÂÀ´×öһЩ¸üºÃµÄÉèÖðɡ£ÈÃmysql¸üºÃµÄÔËÐаɡ£
cp /usr/local/mysql/share/mysql/my-medium.cnf /etc/my.cnf
copyÅäÖÃÎļþ,ÓÐlarge,medium,smallÈý¸ö»·¾³ÏµÄ,¸ù¾Ý»úÆ÷ÐÔÄÜÑ¡Ôñ,Èç¹û¸ººÉ±È½Ï´ó,¿ÉÐÞ¸ÄÀïÃæµÄһЩ±äÁ¿µÄÄÚ´æʹÓÃÖµ
ÉèÖÃ×Ô¶¯Æô¶¯mysql
É趨¿ª»ú×ÔÆô¶¯mysql
#cd /usr/local/mysql/share/mysql
#cp mysql.server /etc/init.d/mysql
#cd /etc/rc3.d
#ln -s ../init.d/mysql S100mysql
#ln -s ../init.d/mysql K100mysql
#cd /etc/rc5.d
#ln -s ../init.d/mysql S10
Ïà¹ØÎĵµ£º
½¨Á¢Íâ¼üµÄÇ°Ì᣺ ±¾±íµÄÁбØÐëÓëÍâ¼üÀàÐÍÏàͬ(Íâ¼ü±ØÐëÊÇÍâ±íÖ÷¼ü)¡£
Íâ¼ü×÷Ó㺠ʹÁ½ÕűíÐγɹØÁª£¬Íâ¼üÖ»ÄÜÒýÓÃÍâ±íÖеÄÁеÄÖµ£¡
Ö¸¶¨Ö÷¼ü¹Ø¼ü×Ö£º foreign key(ÁÐÃû)
ÒýÓÃÍâ¼ü¹Ø¼ü×Ö£º references <Íâ¼ü±íÃû>(Íâ¼üÁÐÃû)
ʼþ´¥·¢ÏÞÖÆ: on deleteºÍon update , ¿ÉÉè²ÎÊýcascade(¸úËæÍâ¼ü¸Ä¶¯ ......
ÔÚMySQL 3.23.44°æ±¾ºó£¬InnoDBÒýÇæÀàÐ͵ıíÖ§³ÖÁËÍâ¼üÔ¼Êø¡£
Íâ¼üµÄʹÓÃÌõ¼þ£º
1.Á½¸ö±í±ØÐëÊÇInnoDB±í£¬MyISAM±íÔÝʱ²»Ö§³ÖÍâ¼ü£¨¾Ý˵ÒÔºóµÄ°æ±¾ÓпÉÄÜÖ§³Ö£¬µ«ÖÁÉÙÄ¿Ç°²»Ö§³Ö£©£»
2.Íâ¼üÁбØÐ뽨Á¢ÁËË÷Òý£¬MySQL 4.1.2ÒÔºóµÄ°æ±¾ÔÚ½¨Á¢Íâ¼üʱ»á×Ô¶¯´´½¨Ë÷Òý£¬µ«Èç¹ûÔÚ½ÏÔçµÄ°æ±¾ÔòÐèÒªÏÔʾ½¨Á¢£»
3.Íâ¼ü¹ØÏ ......
¶ÔÓÚʹÓà MySQL Õâ¸öÊý¾Ý¿âϵͳµÄÓû§À´Ëµ£¬Ëü²»½ö¿ªÔ´£¬Îȶ¨£¬Ð§ÂÊÒ²ºÜ¸ß¡£µ«ÓÐʱҲ»áÓöµ½Ò»Ð©ÐÔÄÜ·½ÃæµÄÎÊÌâ¡£Ò»°ãÇé¿ö¿ÉÄÜ»áÓÐÒÔϼ¸ÖÖ¿ÉÄÜ£º
1. Êý¾Ý±íµÄË÷ÒýûÓкÏÀíµÄ½¨ºÃ»òʹÓá£
2. SQLÓï¾ä¹ýÓÚ¸´ÔÓ£¬£¨×ó/ÓÒÁ¬½Ó£¬¶à±í²éѯµÈ£©¡£
3. ·þÎñÆ÷ÅäÖò»ºÏÀí¡£
4. ·þÎñÆ÷±¾ÉíµÄ´¦ÀíÄÜ ......
MySQL ´æ´¢¹ý³ÌÊÇ´Ó MySQL 5.0 ¿ªÊ¼Ôö¼ÓµÄй¦ÄÜ¡£´æ´¢¹ý³ÌµÄÓŵãÓÐÒ»Âá¿ð¡£²»¹ý×îÖ÷ÒªµÄ»¹ÊÇÖ´ÐÐЧÂʺÍSQL ´úÂë·â×°¡£ÌرðÊÇ SQL ´úÂë·â×°¹¦ÄÜ£¬Èç¹ûûÓд洢¹ý³Ì£¬ÔÚÍⲿ³ÌÐò·ÃÎÊÊý¾Ý¿âʱ£¨ÀýÈç PHP£©£¬Òª×éÖ¯ºÜ¶à SQL Óï¾ä¡£ÌرðÊÇÒµÎñÂß¼¸´ÔÓµÄʱºò£¬Ò»´ó¶ÑµÄ SQL ºÍÌõ¼þ¼ÐÔÓÔÚ PHP ´úÂëÖУ¬ÈÃÈ˲»º®¶øÀõ¡£ÏÖÔÚÓÐÁË My ......
[Ô´´] MySQL Proxy ѧϰ±Ê¼Ç
×÷Õߣºheiyeluren
ʱ¼ä£º2008-1-28
²©¿Í£ºhttp://blog.csdn.net/heiyeshuwu
¡¾ ²âÊÔƽ̨ ¡¿
·þÎñÆ÷¶Ë£º
OS£ºFreeBSD 6.2
Lua£º 5.1.1
MySQL Server£º4.1.22-log
MySQL Proxy£º 0.6.0
¿Í»§¶Ë£º
OS£ºWindows XP Pro SP2
PHP£º PHP 5.2.4 (cli)
MySQL Client£º Ver 14.13 Distrib ......