Linux下MySQL源码安装安装常见错误

1 编译并安装报错

场景

如果报如下错误

[root@mysql mysql-5.6.12]# cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/mydata/data -DSYSCONFDIR=/etc -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_ARCHIVE_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DWITH_READLINE=1 -DWITH_SSL=bundled -DWITH_ZLIB=bundled -DWITH_LIBWRAP=0 -DMYSQL_UNIX_ADDR=/tmp/mysql.sock -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci 
-- Running cmake version 2.8.11.2 
-- MySQL 5.6.12 
-- Packaging as: mysql-5.6.12-Linux-x86_64 
-- HAVE_VISIBILITY_HIDDEN 
CMake Error at cmake/ssl.cmake:164 (FILE): 
  file STRINGS file  "/root/src/mysql-5.6.12/OPENSSL_INCLUDE_DIR-NOTFOUND/openssl/opensslv.h"
  cannot be read. 
Call Stack (most recent call first): 
  CMakeLists.txt:323 (MYSQL_CHECK_SSL) 
-- OPENSSL_INCLUDE_DIR = OPENSSL_INCLUDE_DIR-NOTFOUND 
-- OPENSSL_LIBRARY = OPENSSL_LIBRARY-NOTFOUND 
-- CRYPTO_LIBRARY = CRYPTO_LIBRARY-NOTFOUND 
-- OPENSSL_MAJOR_VERSION = 
CMake Error at cmake/ssl.cmake:231 (MESSAGE): 
  Cannot find appropriate system libraries for SSL.  Use WITH_SSL=bundled to 
  enable SSL support 
Call Stack (most recent call first): 
  CMakeLists.txt:323 (MYSQL_CHECK_SSL) 
-- HAVE_VISIBILITY_HIDDEN 
-- HAVE_VISIBILITY_HIDDEN 
-- Could NOT find Curses (missing:  CURSES_LIBRARY CURSES_INCLUDE_PATH) 
CMake Error at cmake/readline.cmake:85 (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:128 (FIND_CURSES) 
  cmake/readline.cmake:202 (MYSQL_USE_BUNDLED_EDITLINE) 
  CMakeLists.txt:325 (MYSQL_CHECK_EDITLINE) 
-- Configuring incomplete, errors occurred!

从上面的错误中我们可以很清楚的看到缺少两个依赖包

解决方法

安装openssl，之后删除当前目录下CMakeCache.txt文件并重新编译
[root@mysql mysql-5.6.42]# yum install –y openssl openssl-devel ncurses ncurses-devel
[root@mysql mysql-5.6.42]# mkdir CMakeCache.txt

2 初始化MySQL脚本报错

场景

解决方法 ：

#安装autoconf库
yum-y install autoconf