mysql編譯方式安裝

1、cmake包安裝

上傳cmake-2.8.8.tar.gz到opt下，解壓tar xf cmake-2.8.8.tar.gz。

執行./configure，報錯如下：

Error when bootstrapping CMake:

Cannot find appropriate C++ compiler on this system.

這是由于最小化安裝centos後，沒有安裝cc編譯器，是以yum install gcc、yum install gcc-c++

再次執行./configure成功。執行gmake，gmake install。

2、mysql安裝

編譯mysql

cmake -DCMAKE_INSTALL_PREFIX=/mysql \

-DMYSQL_DATADIR=/mysql/data \

-DSYSCONFDIR=/etc \

-DWITH_MYISAM_STORAGE_ENGINE=1 \

-DWITH_INNOBASE_STORAGE_ENGINE=1 \

-DWITH_MEMORY_STORAGE_ENGINE=1 \

-DWITH_READLINE=1 \

-DMYSQL_UNIX_ADDR=/mysql/mysql.sock \

-DMYSQL_TCP_PORT=3306 \

-DENABLED_LOCAL_INFILE=1 \

-DWITH_PARTITION_STORAGE_ENGINE=1 \

-DEXTRA_CHARSETS=all \

-DDEFAULT_CHARSET=utf8 \

-DDEFAULT_COLLATION=utf8_general_ci

執行報錯，如下：

CMake Error at cmake/readline.cmake:83 (MESSAGE):Curses library not found.

Please install appropriate package,remove CMakeCache.txt and rerun cmake.On Debian/Ubuntu, package name is libncurses5-dev, on Redhat and derivates it is ncurses-devel.

Call Stack (most recent call first):

cmake/readline.cmake:127 (FIND_CURSES)

cmake/readline.cmake:217 (MYSQL_USE_BUNDLED_LIBEDIT)

CMakeLists.txt:269 (MYSQL_CHECK_READLINE)

原因是操作未安裝ncurses-devel，安裝yum install ncurses-devel。再次執行編譯，成功。

執行make && make install 安裝。

複制cp /mysql/support-files/my-small.cnf /etc/ ,cp /mysql/support-files/mysql.server /etc/init.d/mysqld

啟動/etc/init.d/mysqld start ，報錯Starting MySQL. ERROR! The server quit without updating PID file (/mysql/ares.pid).

檢視日志資訊more /mysql/data/ares.err ，報錯為190331 10:44:35 [ERROR] Fatal error: Can't change to run as user 'mysql' ; Please check that the user exists!

添加使用者mysql後，更改mysql目錄權限，/etc/init.d/mysqld start 啟動成功。