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

linuxÏ°²×°mysqlµÄÈýÖÖ·½Ê½

±¾´Î°²×°µÄϵͳƽ̨Ϊredhat 5
Ò»¡¢Ê¹ÓÃRPM°ü½øÐа²×°
  Ê×ÏÈ¿ÉÒÔ´Ó°²×°¹âÅÌÖлòÕßµ½mysqlµÄÍøÕ¾ÉÏÏÂÔضÔÓ¦°æ±¾µÄrpm°üÈçÏ£º
MySQL-server-community-5.1.38-0.rhel5.i386.rpm
MySQL-client-community-5.1.38-0.rhel5.i386.rpm
    ½Ó×ÅÎÒÃÇ¿ÉÒÔʹÓÃrpmÃüÁî½øÐа²×°£º
rpm -ivh MySQL-server-community-5.1.38-0.rhel5.i386.rpm
rpm -ivh MySQL-client-community-5.1.38-0.rhel5.i386.rpm
¶þ¡¢°²×°¶þ½øÖÆ°ü
²½ÖèÈçÏ£º
1¡¢ÓÃrootµÇ¼ϵͳ£¬Ôö¼ÓmysqlÓû§ºÍ×é
groupadd mysql
useradd -g mysql mysql
2¡¢½âѹ¶þ½øÖÆ°ü£¬¼ÙÈç¶þ½øÖÆ°ü·ÅÔÚ/home/mysqlÏ£¬ÎÒÃÇÔÚ½âѹºó²¢Ôö¼ÓÒ»¸ö·ûºÅÁ´½Ó
tar xvfz mysql-5.1.38-linux-i686-glibc23.tar.gz
ln -s mysql-5.1.38-linux-i686-glibc23 mysql
3¡¢ÔÚÊý¾Ý¿âĿ¼Ï´´½¨ÏµÍ³Êý¾Ý¿âµÄ±í£¬--user±íʾÕâЩÊý¾Ý¿âºÍ±íµÄËùÓÐÕßΪ´ËÓû§
cd mysql
./scripts/mysql_install_db --user=mysql
4¡¢ÉèÖÃĿ¼ȨÏÞ£¬½«dataĿ¼µÄËùÓÐÕ߸ÄΪmysql£¬ÆäËüĿ¼µÄÎļþµÄËùÓÐÕßΪroot
chown -R root:mysql .
chown -R mysql:mysql data
5¡¢Æô¶¯mysql
./bin/mysqld_safe --user=mysql &
Èý¡¢Ô´Âë°²×°mysql
1¡¢ÓÃrootµÇ¼ϵͳ£¬Ôö¼ÓmysqlÓû§ºÍ×é
groupadd mysql
useradd -g mysql mysql
2¡¢½âѹԴÂë°ü£¬²¢½øÈë½âѹºóµÄĿ¼
tar xvfz mysql-5.1.38.tar.gz
cd mysql-5.1.38
3¡¢ÓÃconfigure¹¤¾ßÀ´±àÒëÔ´´úÂ룬ÕâÀïÎÒÃÇ¿ÉÒÔʹÓúܶàµÄ²ÎÊý£¬¾ßÌå¿ÉÒÔÓÃconfigure --helpÀ´²é¿´£¬ÕâÀïÎÒÃǽ«mysql°²×°µ½/usr/local/mysqlÏÂ
./configuer --prefix=/usr/local/mysql
make
make install
4¡¢Ñ¡ÔñÒ»¸öÑùÀýÅäÖÃÎļþ£¬²¢¸´ÖƵ½/etc/ϸÄÃûΪmy.cnf
cp support-files/my-medium.cnf /etc/my.cnf
5¡¢ÔÚÊý¾Ý¿âĿ¼Ï´´½¨ÏµÍ³Êý¾Ý¿âµÄ±í£¬--user±íʾÕâЩÊý¾Ý¿âºÍ±íµÄËùÓÐÕßΪ´ËÓû§
cd /usr/local/mysql
./bin/mysql_install_db --user=mysql
6¡¢ÉèÖÃĿ¼ȨÏÞ£¬½«varĿ¼µÄËùÓÐÕ߸ü¸ÄΪmysql,ÆäËüĿ¼ºÍÎļþµÄËùÓÐÕßΪroot
chown -R root .
chown -R mysql var
chgrp -R mysql .
7¡¢Æô¶¯mysql
./bin/mysqld_safe --user=mysql &


Ïà¹ØÎĵµ£º

MySQL phpMyAdmin °²×°

Ê×ÏÈ°²×°phpMyadmin
[root@aladdin phpMyAdmin]# uname -a
Linux aladdin.leadtek.com.cn 2.6.32.11-99.fc12.i686.PAE #1 SMP Mon Apr 5 16:15:03 EDT 2010 i686 i686 i386 GNU/Linux
[root@aladdin phpMyAdmin]# yum info phpmyadmin
Loaded plugins: presto, refresh-packagekit
Installed Packages
Name &nbs ......

MYSQLÍâ¼ü(Foreign Key)µÄʹÓ㨶þ£©

×÷ÕߣºDirk (dirk.ye AT gmail.com)
Url£ºhttp://dirk.pdx.cn
ÈÕÆÚ£º2004/12/08
Ê×ÏÈ£¬Ä¿Ç°ÔÚ²úÆ·»·¾³¿ÉÓõÄMySQL°æ±¾£¨Ö¸4.0.xºÍ4.1.x£©ÖУ¬Ö»ÓÐInnoDBÒýÇæ²ÅÔÊÐíʹÓÃÍâ¼ü£¬ËùÒÔ£¬ÎÒÃǵÄÊý¾Ý±í±ØÐëʹÓÃ
InnoDBÒýÇæ¡£
ÏÂÃ棬ÎÒÃÇÏÈ´´½¨ÒÔϲâÊÔÓÃÊý¾Ý¿â
񡜧
CREATE TABLE `roottb` (
`id` INT(11) UNSIGNED AU ......

WEB³ÌÐòÔ±ÐèÒªÕÆÎÕµÄÊ®´óMySQLÓÅ»¯¼¼ÇÉ

1.ÓÅ»¯ÄãµÄMySQL²éѯ»º´æ
ÔÚMySQL·þÎñÆ÷ÉϽøÐвéѯ£¬¿ÉÒÔÆôÓøßËÙ²éѯ»º´æ¡£ÈÃÊý¾Ý¿âÒýÇæÔÚºǫ́ÇÄÇĵĴ¦ÀíÊÇÌá¸ßÐÔÄܵÄ×îÓÐЧ·½·¨Ö®Ò»¡£µ±Í¬Ò»¸ö²éѯ±»Ö´Ðжà´Îʱ£¬Èç¹û½á¹ûÊÇ´Ó»º´æÖÐÌáÈ¡£¬ÄÇÊÇÏ൱¿ìµÄ¡£
µ«Ö÷ÒªµÄÎÊÌâÊÇ£¬ËüÊÇÄÇôÈÝÒ×±»Òþ²ØÆðÀ´ÒÔÖÁÓÚÎÒÃÇ´ó¶àÊý³ÌÐòÔ±»áºöÂÔËü¡£ÔÚÓÐЩ´¦ÀíÈÎÎñÖУ¬ÎÒÃÇʵ¼ÊÉÏÊÇ¿ÉÒÔ×è ......

MysqlÓÅ»¯¼¼ÇÉ

×ܽáÁËһЩMySQLÓÅ»¯·½ÃæµÄ¼¼ÇÉ
Ò». Æô¶¯²ÎÊýÓÅ»¯
ÐÞ¸Ä my.cnf (»òÕßmy.ini)£¬¼ÓÈë/ÐÞ¸ÄÒÔϼ¸ÐÐ
#É趨»º´æµÄÁ¬½ÓÊý,½ÚÊ¡Á¬½ÓʱµÄ¿ªÏú
back_log = 64
#½ûÓÃÎļþϵͳÍⲿËø
external-locking = 0
#½ûÓÃBDB,Èç¹ûÄãȷʵ²»ÐèÒªµÄ»°,innodbÒ²ÊÇÈç´Ë
skip-bdb
#Ë÷Òý»º³å,Èç¹ûÊÇרÓõÄÊý¾Ý¿â·þÎñÆ÷,¿ÉÒÔÉèÖøߴï·þÎñÆ÷ÄÚ´ ......

Linuxϵͳµ÷Óà sigactionº¯ÊýÏê½â(Ò»)

¹¦ÄÜÃèÊö£º 
´¦ÀíÐźš£¼È¿ÉÓÃÓÚÉ趨¶ÔÈÎÒâÐźŵĴ¦Àí·½Ê½£¬Ò²¿ÉÓÃÓÚ¼ìÑé¸ÃÐźŵÄÄ¿Ç°Ô¤Éè´¦Ö÷½Ê½¡£
 
  
Ó÷¨£º 
#include <signal.h>
int sigaction(int signum, const struct sigaction *act, struct sigaction *oldact);
       
 &n ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ