centos下编译安装mysql报错解决方案

下面是在CentOS下编译安装MySQL出现错误的解决方案攻略：

1. 安装编译所需的依赖库

在进行MySQL的编译安装前,需要安装一些必要的依赖库.执行以下命令安装：

yum install -y gcc gcc-c++ ncurses-devel cmake autoconf libtool libaio

wget https://dev.mysql.com/get/Downloads/MySQL-⑤7/mysql-⑤⑦29.tar.gz

③ 解压源码包并进行配置

解压源码包,并进入源码包所在目录,执行以下命令进行配置：

tar -zxvf mysql-⑤⑦29.tar.gz
cd mysql-⑤⑦29
cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql \
-DWITH_ZLIB=system

其中,-DCMAKE_INSTALL_PREFIX指定了MySQL安装路径,-DWITH_BOOST指定了Boost库的安装路径,-DSYSCONFDIR指定了配置文件的路径,其他的是一些常用配置项.

④ 进行编译和安装

执行以下命令进行编译和安装：

make  make install

⑤ 配置MySQL

执行以下命令进行配置：

cd /usr/local/mysql
cp support-files/my-default.cnf /etc/my.cnf
bin/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data

⑥ 启动MySQL

执行以下命令启动MySQL：

bin/mysqld_safe --user=mysql 

如果出现以下错误：

Starting mysqld daemon with databases from /usr/local/mysql/data
2018-04-12T10:02:1④067788Z mysqld_safe Logging to '/usr/local/mysql/data/servername.err'.
2018-04-12T10:02:1④367451Z mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data
/usr/local/mysql/bin/mysqld: error while loading shared libraries: libncurses.so.5: cannot open shared object file: No such file or directory
2018-04-12T10:02:1④399128Z mysqld_safe mysqld from pid file /usr/local/mysql/data/servername.pid ended

则需要执行以下命令安装相应的库：

yum install -y ncurses-devel

Starting mysqld daemon with databases from /usr/local/mysql/data
2018-04-12T10:06:4⑦573063Z mysqld_safe Logging to '/usr/local/mysql/data/servername.err'.
2018-04-12T10:06:4⑦874128Z mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data
2018-04-12T10:06:4⑦942250Z mysqld_safe mysqld from pid file /usr/local/mysql/data/servername.pid ended

则需要查看错误日志文件,命令如下：

cat /usr/local/mysql/data/servername.err

根据错误日志文件中的提示进行排错.

至此,CentOS下编译安装MySQL报错的解决方案攻略完成.

以上就是土嘎嘎小编为大家整理的centos下编译安装mysql报错解决方案相关主题介绍,如果您觉得小编更新的文章只要能对粉丝们有用,就是我们最大的鼓励和动力,不要忘记讲本站分享给您身边的朋友哦！！