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 &
Ïà¹ØÎĵµ£º
´´½¨×ÀÃæͼ±ê
Ä¿Ç°½«ÍøÂçÓ¦ÓÃÀ©Õ¹µ½×ÀÃæÊÇÒ»¸öÇ÷ÊÆ£¬´æÔÚןܶà½â¾ö·½°¸£¬±¾ÎÄÒÔ Mozilla Prism ΪÀý£¬ÀàËƵķ½·¨Í¬ÑùÊÊÓÃÓÚ Google Chrome ¡£
1. µ½ Mozilla Prism µÄÍøÕ¾ÉÏÏÂÔØ Prism£¬µã»÷ Download Now Ö®ºó»áÌáʾÓÐÁ½ÖÖ£¬Ò»ÖÖÊÇÒÔ Mozilla Firefox À©Õ¹µÄ·½Ê½£¬ÊʺÏÒѾ°²×°ÓÐ Firefox µÄÅóÓÑ£»Ò»Ö ......
MySQL °æ±¾£º5.0.45 phpMyAdmin°æ±¾£º2.11.3
Ê×ÏÈ¿´MySQL 5.0²Î¿¼ÊÖ²áÖйØÓÚ´´½¨´æ´¢¹ý³ÌµÄÓ﷨˵Ã÷£º
CREATE
[DEFINER = { user | CURRENT_USER }]
PROCEDURE sp_name ([proc_parameter[,...]])
[characteristic ...] r ......
MySQL°æ±¾: Server version: 5.1.44 Source distribution
ÐÞ¸ÄrootÃÜÂë
Èç¹ûûÓÐÃÜÂëʹÓÃÏÂÃæµÄÃüÁî, ½«ÃÜÂëÉèΪ"123456"
$ mysqladmin -u root password 123456
Èç¹ûÓÐÃÜÂëʹÓÃÏÂÃæµÄÃüÁî, ½«ÃÜÂë¸ÄΪ"123456"
$ mysqladmin -u root -p password 123456
Enter password:
Óû§ÕË»§¹ÜÀí
Ìí¼ÓÕË» ......
1¡¢´ò¿ªMyEclipse6.6
2¡¢Ñ¡Ôñ²Ëµ¥£ºWindow/Open Perspective/MyEclipse Database Explorer£¬µã»÷OK£¬ÔÚ×ó±ß´ò¿ªDB Brower´°¿Ú¡£
3¡¢ÔÚDB Brower´°¿ÚÄÚÈÎÒâ¿Õ°×´¦»÷ÓÒ¼ü£¬Ñ¡ÔñNewÃüÁµ¯³öDatabase Driver´°¿Ú
4¡¢±¾´°¿Ú¸÷Ïî˵Ã÷£º
Driver template: MySQL Connector/J Ñ¡ÔñÇý¶¯Ä£°å
& ......
Öܺ£ºº /ÎÄ
2010.4.22
¿´¼¯ÈºµÄ¶«Î÷ʱÎÞÒâÖп´µ½¼¸ÄêÇ°Á÷Ðеķֲ¼Ê½¿Æѧ¼ÆËãseti@home£¬ÃÀ¹ú²®¿ËÀû´óѧµÈ¿Æѧ½çÓÃÓÚ¼ÆËãÌìÌåÊý¾ÝµÄ¡£SETI@home ÊÇÒ»ÏîÀûÓÃÈ«ÇòÁªÍøµÄ¼ÆËã»ú¹²Í¬ËÑÑ°µØÍâÎÄÃ÷£¨SETI£©µÄ¿ÆѧʵÑé¼Æ»®¡£Äã¿ÉÒÔͨ¹ýÔËÐÐÒ»¸öÃâ·Ñ³ÌÐòÏÂÔز¢·ÖÎö´ÓÉäµçÍûÔ¶¾µ´«À´µÄÊý¾ÝÀ´¼ÓÈëÕâ¸öÏîÄ¿¡£ ²»¹ýÎÒÔÙ´ÎʹÓÃÆä¿Í»§¶ËÊ ......