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 启动成功。