CentOS 5.6下源碼安裝MySQL 5.1.56

install_mysql_centos5.6
總結：其實事情很簡單，答案一直就在跟前，我們卻總很容易將他們忽視掉，用心想，靜靜地看，答案就在那里。

1. download mysql-5.1.56.tar.gz to /opt/src

2. $cd /opt/src

3. $tar -zxvf mysql-5.1.56.tar.gz-
 

4. $cd mysql-5.1.56

5. $mkdir -p /opt/apps/mysql-5.1.56 /opt/etc/mysql /opt/var/mysql
                /opt/tmp/mysql

6. $./configure --prefix=/opt/apps/mysql-5.1.56/   \
        --sysconfdir=/opt/etc/mysql/          \
        --localstatedir=/opt/var/mysql/  \
        --with-unix-socket-path=/opt/tmp/mysql/mysql.sock \
        --with-tcp-port=3306 \
        --with-charset=utf8 \
        --with-extra-charsets=gb2312,gbk

7. $make

8. $make install

9. $su - root

10.$sudo cp /opt/src/support-files/my-medium.cnf /etc/my.cnf

11.$sudo groupadd mysql

12.$sudo useradd -g mysql mysql

13.$sudo chown -R mysql:mysql /opt/var/mysql

14.$sudo chown -R mysql:mysql /opt/tmp/mysql/

14.$ln -s /opt/apps/mysql-5.1.56 /opt/apps/mysql

15.$sudo vim /etc/my.cnf
        instead skip-locking by #skip-locking
      add:
            skip-external-locking

16.$sudo ./mysql/bin/mysql_install_db --user=mysql
        note:
            generate the initial privileges or grant tables

17. 啟動mysql服務
    $sudo /opt/apps/mysql/bin/mysqld_safe &
        note:
            starts the mysqld_safe daemon, which will in turn start the MySQL server mysqld.
            If the mysqld daemon crashes,mysqld_safe will restart it.
            The ampersand instructs the shell to run the daemon in the background.

18.關閉mysql服務
    $/opt/apps/mysql/bin/mysqladmin -u root shutdown

19.設置root密碼
    $/opt/apps/mysql/bin/mysqladmin -u root password 'new-password'

20.設置密碼后，關閉服務
    $/opt/apps/mysql/bin/mysqladmin -uroot -ppassword shutdown
    或者
    $/opt/apps/mysql/bin/mysqladmin -u root -p shutdown

21. 登錄mysql
    $mysql -u root -p
    或者
    $mysql -uroot -ppasswd

22.設置開機啟動
    $su - root
    #cp /opt/src/mysql-5.1.56/support-files/mysql.server /etc/init.d/mysql
            注：place the startup file for the server in the server's initial daemons directory
                with the name mysql.
    #chmod +x /etc/init.d/mysql
    #chkconfig --add mysql 
            注：set the run level of the service for startup and shutdown

23. 至此可以通過相關設置
    #chkconfig mysql off         //設置不隨機啟動
    #chkconfig mysql on          //重新隨即啟動

24.啟動mysql也可以更加方便
    #/etc/init.d/mysql start       //啟動
    #/etc/init.d/mysql stop       //關閉
    #/etc/init.d/mysql restart
    或者
    #service mysql start
    ....................................

1. error: No curses/termcap library found
         sudo yum install ncurses-devel
        curses構成了一個工作在底層終端代碼之上的封裝，并向用戶提供了一個靈活高效的API
        （Application Programming Interface 應用程序接口）。它提供了移動光標，
        建立窗口，產生顏色，處理鼠標操作等功能。使程序員編寫應用程序不需要關心那些底層的
        終端操作。
        ncurses是最早的System V Release 4.0 (SVr4)中 CURSES的一個克隆。這是一個
        可自由配置的庫，完全兼容舊版本的curses。簡而言之，它是一個管理應用程序在字符終
        端顯示的函數庫。當后面提到curses的時候，同時也可以和NCURSES互換。

2. exec: g++: not found
        sudo yum install gcc-c++

3.  錯誤：對 C++ 內建類型 ‘bool’ 的重聲明
        重新./configure一下，然后再make就好了。

4.  '--skip-locking' is deprecated and will be removed in a future release.             Please use '--skip-external-locking' instead.、

5.  執行腳本
    $sudo ./mysql/bin/mysql_install_db --user=mysql
    時，出現的話，你看過嗎，卻傻巴垃圾的去問人，去google.
    Installing MySQL system tables...
OK
Filling help tables...
OK

To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:

/opt/apps/mysql-5.1.56/bin/mysqladmin -u root password 'new-password'
/opt/apps/mysql-5.1.56/bin/mysqladmin -u root -h net.yy.com password 'new-password'

Alternatively you can run:
/opt/apps/mysql-5.1.56/bin/mysql_secure_installation

which will also give you the option of removing the test
databases and anonymous user created by default.  This is
strongly recommended for production servers.

See the manual for more instructions.

You can start the MySQL daemon with:
cd /opt/apps/mysql-5.1.56 ; /opt/apps/mysql-5.1.56/bin/mysqld_safe &

You can test the MySQL daemon with mysql-test-run.pl
cd /opt/apps/mysql-5.1.56/mysql-test ; perl mysql-test-run.pl

Please report any problems with the /opt/apps/mysql-5.1.56/bin/mysqlbug script!

服務器租用/服務器托管中國五強！虛擬主機域名注冊頂級提供商！15年品質保障！--億恩科技[ENKJ.COM]