CentOS 6下編譯安裝mySQL5的過程

129次閱讀

共計 3026 個字符，預計需要花費 8 分鐘才能閱讀完成。

本篇內容介紹了“CentOS 6 下編譯安裝 mySQL5 的過程”的有關知識，在實際案例的操作過程中，不少人都會遇到這樣的困境，接下來就讓丸趣 TV 小編帶領大家學習一下如何處理這些情況吧！希望大家仔細閱讀，能夠學有所成！

一, 準備工作
1, 快速安裝安裝 CentOS6, 安裝時選擇最小化安裝.
2, 安裝編譯時需要的庫文件, 這時可以選擇做光盤 yum
[root@admin share] # cd /media/
[root@admin media] # mkdir CentOS
[root@admin media] # mount /dev/cdrom /media/CentOS
[root@admin media]# cd /etc/yum.repos.d/
[root@admin yum.repos.d] # mv CentOS-Base.repo CentOS-Base.repo.bak
[root@admin yum.repos.d] # mv CentOS-Debuginfo.repo CentOS-Debuginfo.repo.bak
至此, 用光盤做的 yum 就可用了;
[root@admin ~]#yum –enablerepo=c6-media install ncurses* gcc* perl* -y
3, 準備好安裝包. (這里以 mysql-5.0.56.tar.gz 舉例)
4, 添加 mysql 用戶
[root@admin ~]#groupadd mysql
[root@admin ~]#useradd -g mysql mysql -s /bin/nologin

二, 正式安裝
1. [root@admin software]#tar zxvf mysql-5.0.56.tar.gz
2. [root@admin software]# cd mysql-5.0.56
3. [root@admin mysql-5.0.56]# ./configure –prefix=/usr/local/mysql –localstatedir=/data/mysql –enable-assembler — enable-static –with-mysqld-user=mysql –with-big-tables –enable-thread-safe-client — enable-local-infile –with-charset-utf8 –with-extra-charsets=all
4. [root@admin mysql-5.0.56]# make make install
5. [root@admin mysql-5.0.56]# cp support-files/my-medium.cnf /etc/my.cnf
6. [root@adim share]# cd /usr/local/mysql/
7. [root@admin mysql]# bin/mysql_install_db –user=mysql
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:
/usr/local/mysql/bin/mysqladmin -u root password new-password
/usr/local/mysql/bin/mysqladmin -u root -h localhost.localdomain password new-password

Alternatively you can run:
/usr/local/mysql/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 /usr/local/mysql ; /usr/local/mysql/bin/mysqld_safe

You can test the MySQL daemon with mysql-test-run.pl
cd mysql-test ; perl mysql-test-run.pl

Please report any problems with the /usr/local/mysql/bin/mysqlbug script!

The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at http://shop.mysql.com

8. [root@admin mysql]# chown -R mysql.mysql /data/mysql/
9. [root@admin mysql]# share/mysql/mysql.server start
Starting MySQL SUCCESS! #————– 看到如此, 便知道安裝成功了.
10. [root@admin mysql]# netstat -tunlp | grep mysql
tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN 13193/mysqld

三. 后緒工作
1.[root@admin ~]# ln -s /usr/local/mysql/share/mysql/mysql.server /etc/init.d/mysqld
2.[root@admin ~]# ln -s /usr/local/mysql/bin/mysql /usr/sbin/mysql
3.[root@admin ~]# ln -s /usr/local/mysql/bin/mysqladmin /usr/sbin/mysqladmin
4.[root@admin ~]# ln -s /usr/local/mysql/bin/mysqldump /usr/sbin/mysqldump
5.[root@admin ~]# mysql -uroot -p
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.0.56-log Source distribution

Type help; or \h for help. Type \c to clear the buffer.

mysql

“CentOS 6 下編譯安裝 mySQL5 的過程”的內容就介紹到這里了，感謝大家的閱讀。如果想了解更多行業相關的知識可以關注丸趣 TV 網站，丸趣 TV 小編將為大家輸出更多高質量的實用文章！

正文完