安裝前系統準備

1.gcc-c++、ncurses包

# yum install gcc-c++ ncurses-devel

2.GNU make程序包。建議安裝GNU make 3.75以上版本，下載地址http://www.gnu.org/software/make/

# yum install make

3.安裝cmake，用來編譯mysql，MySQL 5.5以后，源碼安裝需要使用CMake來編譯。下載地址http://www.cmake.org

# tar -xvf cmake-3.2.0-.tar.gz

# mv cmake-3.2.0cmake# mv cmake/tmp/# cd/tmp/cmake/# ./bootstrap

# make

# make install

# cmake--version

4.bison程序包。下載地址 http://www.gnu.org/software/bison/

# tar -xvf bison-3.0.tar.gz

# mv bison-3.0bison

# mv bison/tmp

# cd/tmp/bison/# ./cofigure

# make

# make install

# bison--version

5.如果想運行test scripts，還需要安裝perl

創建mysql用戶：

# /usr/sbin/groupadd mysql

#/usr/sbin/useradd -g mysql mysql

編譯安裝：

# tar -xvf mysql-5.5.44.tar.gz

# cd mysql-5.5.44# cmake-DCMAKE_INSTALL_PREFIX=/usr/local/mysql \-DMYSQL_UNIX_ADDR=/tmp/mysqld.sock \-DMYSQL_DATADIR=/var/mysql/data \-DDEFAULT_CHARSET=utf8 \-DDEFAULT_COLLATION=utf8_general_ci \-DEXTRA_CHARSETS=all \-DWITH_EXTRA_CHARSETS:STRING=utf8,gbk \-DWITH_MYISAM_STORAGE_ENGINE=1\-DWITH_INNOBASE_STORAGE_ENGINE=1\-DENABLED_LOCAL_INFILE=1\-DMYSQL_TCP_PORT=3306\-DMYSQL_USER=mysql \-DSYSCONFDIR=/etc

# make

# make install

cmke參數補充說明：

#mysql安裝的主目錄，版本默認為/usr/local/mysql-DCMAKE_INSTALL_PREFIX=/usr/local/mysql

#mysql數據保存的路徑，自定義-DMYSQL_DATADIR=/var/mysql/data

#mysql配置文件地址------The defaultmy.cnf option file directory-DSYSCONFDIR=/etc

#Compile storage engine xxx statically into server

#Storage engines are builtas plugins. You can build a plugin as a staticmodule (compiled into the server)

#or a dynamic module (builtas a dynamic library that must be installed into the server usingthe INSTALL

#PLUGIN statement or the--plugin-load option before it can be used). Some plugins might not support static#or dynamic building.-DWITH_INNOBASE_STORAGE_ENGINE=1

-DWITH_MYISAM_STORAGE_ENGINE=1#Unix socket file

#The Unix socket file path on which the server listensforsocket connections. This must be an absolute path

#name. Thedefault is /tmp/mysql.sock-DMYSQL_UNIX_ADDR=/tmp/mysqld.sock

#數據庫服務器TCP/IP連接的監聽端口，默認為3306-DMYSQL_TCP_PORT=3306#Whether to enable LOCAL capabilityin the client library forLOAD DATA INFILE

#默認為關閉，這里開啟-DENABLED_LOCAL_INFILE=1#數據庫編碼設置-DEXTRA_CHARSETS=all-DDEFAULT_CHARSET=utf8-DDEFAULT_COLLATION=utf8-general_ci

一些相關設置

# mkdir -p /var/mysql/# mkdir-p /var/mysql/data/# mkdir-p /var/mysql/log/# chown-R mysql:mysql /var/mysql/

# cd support-files/

# cp my-medium.cnf /etc/my.cnf

(注意:my-large.cnf適用于1G內存左右的服務器，可以根據自己配置情況選用my-large.cnf 、my-medium.cnf或 my-huge.cnf 等不同配置)

#vi? /etc/my.cnf(編輯此文件，查找并修改以下變量內容：)

basedir=/usr/local/mysql

datadir=/var/mysql/data

mysql 初始化：

# 利用mysql_install_db腳本生成新的MySQL授權表

$ cd/usr/local/mysql/support-files/usr/local/mysql/scripts/mysql_install_db \--defaults-file=/etc/my.cnf \--basedir=/usr/local/mysql \--datadir=/var/mysql/data \--user=mysql

將mysql添加到服務，并配置開機啟動:

# cp mysql.server /etc/init.d/mysqld

# chmod+x /etc/init.d/mysqld

# chkconfig--add mysqld

# chkconfig--level 345 mysqld on

啟動服務：

# service mysqld start

總結

以上是生活随笔為你收集整理的mysql如何源码安装_MySQL源码安装的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。