CentOS5.6下源碼安裝MySQL5.1.56

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

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

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服務(wù)
$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.關(guān)閉mysql服務(wù)
$/opt/apps/mysql/bin/mysqladmin -u root shutdown

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

20.設(shè)置密碼后，關(guān)閉服務(wù)
$/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.設(shè)置開機啟動
$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. 至此可以通過相關(guān)設(shè)置
#chkconfig mysql off //設(shè)置不隨機啟動
#chkconfig mysql on //重新隨即啟動

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


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

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

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

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

5. 執(zhí)行腳本
$sudo ./mysql/bin/mysql_install_db --user=mysql
時，出現(xiàn)的話，，你看過嗎，卻傻巴垃圾的去問人，去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!

聲明：本網(wǎng)頁內(nèi)容旨在傳播知識，若有侵權(quán)等問題請及時與本網(wǎng)聯(lián)系，我們將在第一時間刪除處理。TEL:177 7030 7066 E-MAIL:11247931@qq.com