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
Ïà¹ØÎĵµ£º
µ¼³öÊÇ,ûÓÐÖ¸¶¨±àÂë
·½·¨Ò» phpmyadmin´¦Àí·½Ê½
¼ì²éphp-mbstringÊÇ·ñÓпÉ×°,ûÓа²×°ÉÏ yum -y install php-mbstring
´ò¿ªphpmyadmin Öе¼³ö,ÔÙ´Óphpmyadmin µ¼ÈëÊÇѡȡ¶þÖÆ½ø(binary)
Èç¹û»¹²»ÐÐ,ÔÚmy.cnf mysqldÖмÓÈë default-character=ÄãµÄ±àÂë, ÖØÆômysql ÔÙÊÔ ......
create procedure getInfor2()
BEGIN
declare _abc varchar(200);
declare stopFlag int;
DECLARE cursor_name CURSOR
FOR
select zhuanyuan from server;
DECLARE CONTINUE HANDLER FOR NOT FOUND set stopFlag=1;
OPEN cursor_name;
REPEAT
FETCH cursor_name INTO _abc;
begin
if _abc='root'
the ......
MySQLµÄÒ²Ö§³Ö´æ´¢¹ý³Ì£¬º¯Êý£¬´¥·¢Æ÷¡£
ÒÔϸ÷¸ö¹¦ÄܵÄÏêÊö£¬Ö÷ÒªÊÇʾÀý¡£
/**1.¶¨Òå·Ö¸î·û*/
DELIMITER //
/**2.´´½¨º¯Êý-¼ÆËãÁ½ÊýÖ®ºÍ*/
CREATE FUNCTION f_sum(num1 INT,num2 INT) RETURNS INT
BEGIN
RETURN num1+num2;
END;
//
/**
*3.´´½¨´æ´¢¹ý³Ì
*˼·£º3.1.Óиô洢¹ý³ÌÔòɾ³ý£¬3.2ÓÐʹÓõÄÖмä±í ......
MySQL ÖÐÎÄÏÔʾÂÒÂë
Èç¹ûÄãÓöµ½ÂÒÂëÎÊÌ⣬¿ÉÒÔ´ÓÏÂÃæ¼¸¸öÎÊÌâÖð²½¼ì²é£º
£¨1£©¼ì²éÄãµÄÎļþ´æ´¢±àÂëÊÇ·ñºÍ meta ÉùÃ÷µÄÒ»Ö£¬¼ÙÈçÄãµÄÎļþÊǰ´ÕÕ utf-8 ±àÂë´æ´¢£¬µ«ÊÇ meta È´ÉùÃ÷Ϊ gb2312 £¬½«µ¼ÖÂÂÒÂë¡£
½â¾ö°ì·¨£º½«Ò³Ãæ´æ´¢±àÂëºÍ meta ÉùÃ÷±£³ÖÒ»Ö¡£ÓüÇʱ¾ ......
ʹÓÃUbuntu
Server×÷Ϊ±¾µØ²âÊÔ»·¾³ÒѾÓÐÒ»¶Îʱ¼äÁË£¬Ò»Ö±¶¼ÊÇʹÓÃapt-get·½Ê½À´°²×°¸÷ÖÖÓ¦ÓÃÈí¼þ£¬Í¨¹ýÔ´Âë±àÒë°²×°Ó¦ÓÃÈí¼þÊÇLinuxºÍUnix»·
¾³ÏÂ×î³£Óõķ½Ê½¡£Í¨¹ýÔ´Âë±àÒë°²×°µÄ×î´óºÃ´¦¾ÍÊÇÄãÖªµÀ×Ô¼º×öÁËʲô£¬ÕâÖÖ·½Ê½°²×°Èí¼þ×ÔÓÉÁé»î£¬Ò²ÊÊÓÃÓÚ¸÷ÖÖÆ½Ì¨¡¢Î¬»¤·½±ã£ ......