Ubuntu9.10_server_ϰ²×°Mysql 5.5.0 M2
×÷Õߣº°½Ê¿Î°
Mysql ÓõÄÊÇLinux (non RPM packages)
Ò»¡¢½«mysql-5.5.0-m2-linux-i686-glibc23.tar.gzÏÂÔØµ½/home/ikmb ²¢ÔÚµ±Ç°Ä¿Â¼½âѹ£»
……..
mysql-5.5.0-m2-linux-i686-glibc23/data/mysql/
mysql-5.5.0-m2-linux-i686-glibc23/data/test/
…………
¶þ¡¢´´½¨MySQL×飬½¨Á¢MySQLÓû§²¢¼ÓÈëµ½mysql×éÖÐ
ikmb@ikmb-desktop:~/mysql-5.5.0-m2-linux-i686-glibc23/bin$ sudo groupadd mysql
ikmb@ikmb-desktop:~/mysql-5.5.0-m2-linux-i686-glibc23/bin$ sudo useradd -g mysql mysql
Èý¡¢½øÈëĿ¼/usr/local£¬½âѹËõÃâ°²×°°æ£¬²¢ÔÚ´ËĿ¼Öн¨Á¢ÃûΪmysqlµÄÈíÁ´½Ó
ikmb@ikmb-desktop:~/mysql-5.5.0-m2-linux-i686-glibc23/bin$ cd /usr/local
ikmb@ikmb-desktop:/usr/local$ sudo ln -s /home/ikmb/mysql-5.5.0-m2-linux-i686-glibc23 mysql
ËÄ¡¢É趨Ŀ¼·ÃÎÊȨÏÞ£¬ÓÃmysql_install_db´´½¨MySQLÊÚȨ±í³õʼ»¯£¬²¢ÉèÖÃmysql,rootÕʺŷÃÎÊȨÏÞ
ikmb@ikmb-desktop:/usr/local$ sudo chown 777 -R mysql
ikmb@ikmb-desktop:/usr/local$ sudo chown -R mysql .
ikmb@ikmb-desktop:/usr/local$ sudo chgrp -R mysql .
ikmb@ikmb-desktop:/usr/local$ cd mysql
Îå¡¢Ìí¼ÓMySQLÅäÖÃÎļþ
ikmb@ikmb-desktop:~/mysql-5.5.0-m2-linux-i686-glibc23/support-files$ sudo cp /home/ikmb/mysql-5.5.0-m2-linux-i686-glibc23/support-files/my-large.cnf /etc/my.cnf
Áù¡¢ÐÞ¸Ä/etc/my.cnf
ÔÚ[mysqld] ÏÂÌí¼Ó
basedir = /usr/local/mysql
datadir = /usr/local/mysql/data
×¢£º´Ë²½ÔÚmysql_install_db֮ǰ
Æß¡¢ÓÃmysql_install_db´´½¨MySQLÊÚȨ±í³õʼ»¯£¬×¢ÒâbasedirÑ¡Ïî
ikmb@ikmb-desktop:~/mysql-5.5.0-m2-linux-i686-glibc23/scripts$ sudo ./mysql_install_db --user=mysql --basedir=/home/ikmb/mysql-5.5.0-m2-linux-i686-glibc23
Installing MySQL system tables...
OK
Filling help tables...
OK
………..
/home/ikmb/mysql-5.5.0-m2-linux-i686-glibc23/bin/mysqladmin -u root password 'new-password'
/home/ikmb/mysql-5.5.0-m2-linux-i686-glibc23/bin/mysqladmin -u root -h ikmb-desktop password 'new-password'
Alternatively you can run:
/home/ikmb/mysql-5.5.0-m2-linux-i686-glibc23/bin/mysql_secure_installation
which will
Ïà¹ØÎĵµ£º
À´×Ô£ºhttp://it.china-b.com/zx/linuxsjk/20090525/24129_1.html
ÕªÒª£ºMySQLÊÇÒ»¸ö¸ßËÙ¶È¡¢¸ßÐÔÄÜ¡¢¶àÏ̵߳ĹØÏµÐÍÊý¾Ý¿â
ÖÎÀíϵͳ£¬ÊÊÓÃÆ½Ì¨¶à£¬¿ÉÀ©Õ¹ÐÔÇ¿¡£ÔÚʵ¼ÊÉú²ú»·¾³ÖУ¬²¿ÊðºÍʵÏÖ¾ßÓÐÒ»¶¨¸ºÔؾùºâ¹¦ÄܵÄMySQL·þÎñÆ÷¼¯Èº£¬¶ÔÓÚÌá¸ßÓû§Êý¾Ý¿â
Ó¦ÓÃϵͳµÄÐÔÄÜ¡¢ËٶȺÍÎȶ¨ÐÔ¾ßÓÐÃ÷ÏÔµÄ×÷Óᣱ¾ÎļòÒª½éÉÜÁËÔÚ ......
MySQL5.X¶¼ÒѾ·¢²¼ºÃ¾ÃÁË£¬µ«ÊÇ»¹ÓкܶàÈËÈÏΪMySQLÊDz»Ö§³ÖÊÂÎñ´¦ÀíµÄ£¬Õâ²»µÃ²»¹ÖËûÃÇÊǹª¹ÑÎŵ쬯äʵ£¬Ö»ÒªÄãµÄMySQL°æ±¾
Ö§³ÖBDB»òInnoDB±íÀàÐÍ£¬ÄÇôÄãµÄMySQL¾Í¾ßÓÐÊÂÎñ´¦ÀíµÄÄÜÁ¦¡£ÕâÀïÃæ£¬ÓÖÒÔInnoDB±íÀàÐÍÓõÄ×î¶à£¬ËäÈ»ºóÀ´·¢ÉúÁËÖîÈçOracleÊÕ
¹ºInnoDBµÈÁîMySQL²»Ë¬µÄÊÂÇ飬µ«ÄÇЩÉÌÒµÉϵĶ·ÕùÓë¼¼ÊõÎ޹أ ......
MYSQLÓв»Í¬ÀàÐ͵ÄÈÕÖ¾Îļþ(¸÷×Ô´æ´¢Á˲»Í¬ÀàÐ͵ÄÈÕÖ¾)£¬´ÓËüÃǵ±ÖпÉÒÔ²éѯµ½MYSQLÀï¶¼×öÁËЩʲô£¬¶ÔÓÚMYSQLµÄ¹ÜÀí¹¤×÷£¬ÕâЩÈÕÖ¾ÎļþÊDz»¿ÉȱÉٵġ£
1.´íÎóÈÕÖ¾(The error log)£º¼Ç¼ÁËÊý¾Ý¿âÆô¶¯¡¢ÔËÐÐÒÔ¼°Í£Ö¹¹ý³ÌÖдíÎóÐÅÏ¢£»
2.ISAM²Ù×÷ÈÕÖ¾(The isam log)£º¼Ç¼ÁËËùÓжÔISAM±íµÄÐ޸쬏ÃÈÕÖ¾½ö½öÓÃÓÚµ÷ÊÔISAMģʽ ......
MySQLµÄÒ²Ö§³Ö´æ´¢¹ý³Ì£¬º¯Êý£¬´¥·¢Æ÷¡£
ÒÔϸ÷¸ö¹¦ÄܵÄÏêÊö£¬Ö÷ÒªÊÇʾÀý¡£
/**1.¶¨Òå·Ö¸î·û*/
DELIMITER //
/**2.´´½¨º¯Êý-¼ÆËãÁ½ÊýÖ®ºÍ*/
CREATE FUNCTION f_sum(num1 INT,num2 INT) RETURNS INT
BEGIN
RETURN num1+num2;
END;
//
/**
*3.´´½¨´æ´¢¹ý³Ì
*˼·£º3.1.Óиô洢¹ý³ÌÔòɾ³ý£¬3.2ÓÐʹÓõÄÖмä±í ......
linux
mysql
°²×°½éÉÜ:
linux
·þÎñÆ÷ RedHat 5.0.server.
MySQL
°æ±¾:
ÏÂÔØµØÖ·Á´½Ó:http://dev.mysql
.com/downloads/mysql
/5.1.html
MySQL
·þÎñ¶Ë:MySQL
-server-community-5.1.38-0.rhel5.i386.rpm
MySQL
¿Í»§¶Ë:MySQL
-client-community-5.1.38-0.rhel5.i386.rpm
1 °²×°²½ÖèÊ×ÏȼÓÔØ¹âÇý ......