Mysql°²×°ÅäÖÃ

ϵͳ»·¾³£ºrhel5 (×îС»¯°²×°£¬Ö»°²×°vi¹¤¾ß) Äںˣº2.6.18-8.el5 1¡¢ ÏÂÔرàÒë°²×° #cd /usr/local/src/tarbag #wget http://mysql.byungsoo.net/Downloads/MySQL-5.1/mysql-5.1.38.tar.gz //ÏÂÔØ5.1.38 #tar xzvf mysql-5.1.38.tar.gz -C ../software/ #cd ../software/mysql-5.1.38 #./configure --prefix=/usr/local/mysql //MySQL°²×°Ä¿Â¼ --datadir=/mydata //Êý¾Ý¿â´æ·ÅĿ¼ --with-charset=utf8 //ʹÓÃUTF8¸ñʽ --with-extra-charsets=complex //°²×°ËùÓеÄÀ©Õ¹×Ö·û¼¯ --enable-thread-safe-client //ÆôÓÿͻ§¶Ë°²È«Ïß³Ì --with-big-tables //ÆôÓôó±í --with-ssl //ʹÓÃSSL¼ÓÃÜ --with-embedded-server //±àÒë³Éembedded MySQL library (libmysqld.a), --enable-local-infile //ÔÊÐí´Ó±¾µØµ¼ÈëÊý¾Ý --enable-assembler //»ã±àx86µÄÆÕͨ²Ù×÷·û£¬¿ÉÒÔÌá¸ßÐÔÄÜ --with-plugins=innobase //Êý¾Ý¿â²å¼þ £¨mysql-5.1.36.tag.gz±àÒëµÄʱºòÐèҪȥ³ý´ËÏ -with--plugins=partition //·Ö±í¹¦ÄÜ£¬½«Ò»¸ö´ó±í·Ö¸î³É¶à¸öС±í #make && make install //±àÒëÈ»ºó°²×° ÈôÌáʾ£ºerror: No curses/termcap library found£¬ÔòÐè°²×°ncurses-devel°ü ÈôÌáʾ£ºg++: not found gcc-c++-4.1.2-33.i386.rpm ¶þ¡¢Ð½¨Óû§ºÍ×é #groupadd mysql //½¨MySQL×é #useradd -g mysql -s /sbin/nologin mysql //½¨MySQLÓû§ÊôÓÚMySQL×é Èý¡¢ÅäÖà #chown -R mysql:mysql /usr/local/mysql/ °ÑMySQLĿ¼µÄȨÏÞ¸øMySQLÓû§ºÍ×é #chown -R mysql:mysql /mydata °ÑMySQL´æ·ÅĿ¼µÄȨÏÞ¸øMySQLÓû§ºÍ×é #cp /usr/local/src/software/ mysql-5.1.38/support-files/my-medium.cnf /etc/my.cnf //¿½ÈëÅäÖÃÎļþmy.cnf #/usr/local/mysql/bin/mysql_install_db --user=mysql //ÓÃMySQLÀ´³õʼ»¯Êý¾Ý¿â #chown -R mysql:mysql /usr/local/mysql/var/ //°Ñ³õʼ»¯µÄÊý¾Ý¿âĿ¼¸øMySQLËùÓÐÕß #/usr/local/mysql/bin/mysqld_safe --user=mysql & //Æô¶¯MySQL ËÄ¡¢ÆäËû #cp /usr/local/src/software/ mysql-5.1.38/support-files/mysql.server /etc/init.d/mysqld #chmod 755 /etc/init.d/mysqld #chkconfig --add mysqld #chkconfig mysqld on #service mysqld restart Îå¡¢µÇ½²âÊÔ #cd /usr/local/mysql/bin #mysql >show databases; # MySQL°²×°½áÊø