mysql-5.6.27源码安装及错误解决办法

摘要:
环境:centos6.5.x86 _六十四wgethttp://mirrors.sohu.com/mysql/MySQL-5.6/mysql-5.6.27.tar.gzyuminstall-ycmake当然,您也可以自己下载并安装源代码包。为了方便安装Yum,您可以安装useradd-s/sbin/nologinmysqltarzxvfmysql-5.6.27.tar.gzmkdir-p/data/mysqlshow

环境:centos6.5.x86_64

  1. wgethttp://mirrors.sohu.com/mysql/MySQL-5.6/mysql-5.6.27.tar.gz

  2. yum install -y cmake 当然也可以自己下载源码包安装,为方便就Yum安装了

  3. useradd -s /sbin/nologin mysql

  4. tar zxvf mysql-5.6.27.tar.gz

  5. mkdir -p /data/mysql

  6. chown -R mysql:mysql /data/mysql

  7. cd mysql-5.6.27

  8. cmake.-DCMAKE_INSTALL_PREFIX=/usr/local/mysql-DMYSQL_DATADIR=/mysql/data-DDEFAULT_CHARSET=utf8-DDEFAULT_COLLATION=utf8_general_ci-DWITH_EXTRA_CHARSETS:STRING=all-DWITH_DEBUG=0-DENABLED_LOCAL_INFILE=1
--Runningcmakeversion2.8.12.2
--CouldNOTfindGit(missing:GIT_EXECUTABLE)
--TheCcompileridentificationisunknown
--TheCXXcompileridentificationisunknown
CMakeError:yourCcompiler:"CMAKE_C_COMPILER-NOTFOUND"wasnotfound.PleasesetCMAKE_C_COMPILERtoavalidcompilerpathorname.
CMakeError:yourCXXcompiler:"CMAKE_CXX_COMPILER-NOTFOUND"wasnotfound.PleasesetCMAKE_CXX_COMPILERtoavalidcompilerpathorname.
CMakeErroratcmake/os/Linux.cmake:27(STRING):
stringsub-commandREPLACErequiresatleastfourarguments.
CallStack(mostrecentcallfirst):
CMakeLists.txt:149(INCLUDE)
CMakeErroratcmake/os/Linux.cmake:27(STRING):
stringsub-commandREPLACErequiresatleastfourarguments.
CallStack(mostrecentcallfirst):
CMakeLists.txt:149(INCLUDE)
--MySQL5.6.27
--Packagingas:mysql-5.6.27-Linux-i686
--CouldNOTfindThreads(missing:Threads_FOUND)
--CouldNOTfindThreads(missing:Threads_FOUND)
--Checkifthesystemisbigendian
--Searching16bitinteger
CMakeErrorat/usr/share/cmake/Modules/TestBigEndian.cmake:44(message):
nosuitabletypefound
CallStack(mostrecentcallfirst):
configure.cmake:628(TEST_BIG_ENDIAN)
CMakeLists.txt:398(INCLUDE)
--Configuringincomplete,errorsoccurred!
Seealso"/usr/local/src/mysql-5.6.27/CMakeFiles/CMakeOutput.log".
Seealso"/usr/local/src/mysql-5.6.27/CMakeFiles/CMakeError.log".

分析:

-- Could NOT find Git (missing: GIT_EXECUTABLE)这项应该缺少git包,yum install -y git

-- The C compiler identification is unknown

-- The CXX compiler identification is unknown 这两项缺少gcc和gcc-c++的包,yum install -y gcc gcc-c++

另外需要rmCMakeCache.txt

继续

cmake.-DCMAKE_INSTALL_PREFIX=/usr/local/mysql-DMYSQL_DATADIR=/mysql/data-DDEFAULT_CHARSET=utf8-DDEFAULT_COLLATION=utf8_general_ci-DWITH_EXTRA_CHARSETS:STRING=all-DWITH_DEBUG=0-DWITH_SSL=yes-DWITH_READLINE=1-DENABLED_LOCAL_INFILE=1

出现错误:

CMakeError:Thefollowingvariablesareusedinthisproject,buttheyaresettoNOTFOUND.
PleasesetthemormakesuretheyaresetandtestedcorrectlyintheCMakefiles:
OPENSSL_INCLUDE_DIR
usedasincludedirectoryindirectory/usr/local/src/mysql-5.6.27/CMakeFiles/CMakeTmp
CMakeError:InternalCMakeerror,TryCompileconfigureofcmakefailed
--Checksizeofwchar_t-failed
--Checksizeofwctype_t
CMakeError:Thefollowingvariablesareusedinthisproject,buttheyaresettoNOTFOUND.
PleasesetthemormakesuretheyaresetandtestedcorrectlyintheCMakefiles:
OPENSSL_INCLUDE_DIR
usedasincludedirectoryindirectory/usr/local/src/mysql-5.6.27/CMakeFiles/CMakeTmp
CMakeError:InternalCMakeerror,TryCompileconfigureofcmakefailed
--Checksizeofwctype_t-failed
--Checksizeofwint_t
CMakeError:Thefollowingvariablesareusedinthisproject,buttheyaresettoNOTFOUND.
PleasesetthemormakesuretheyaresetandtestedcorrectlyintheCMakefiles:
OPENSSL_INCLUDE_DIR
usedasincludedirectoryindirectory/usr/local/src/mysql-5.6.27/CMakeFiles/CMakeTmp
CMakeError:InternalCMakeerror,TryCompileconfigureofcmakefailed
--Checksizeofwint_t-failed
--CouldNOTfindCurses(missing:CURSES_LIBRARYCURSES_INCLUDE_PATH)
CMakeErroratcmake/readline.cmake:85(MESSAGE):
Curseslibrarynotfound.Pleaseinstallappropriatepackage,
removeCMakeCache.txtandreruncmake.OnDebian/Ubuntu,packagenameislibncurses5-dev,onRedhatandderivatesitisncurses-devel.
CallStack(mostrecentcallfirst):
cmake/readline.cmake:128(FIND_CURSES)
cmake/readline.cmake:202(MYSQL_USE_BUNDLED_EDITLINE)
CMakeLists.txt:409(MYSQL_CHECK_EDITLINE)
--Configuringincomplete,errorsoccurred!
Seealso"/usr/local/src/mysql-5.6.27/CMakeFiles/CMakeOutput.log".
Seealso"/usr/local/src/mysql-5.6.27/CMakeFiles/CMakeError.log".

分析:

--CouldNOTfindCurses(missing:CURSES_LIBRARYCURSES_INCLUDE_PATH)

缺少ncurses-devel包,yum install -yncurses-devel

rm CMakeCache.txt

通过阅读官方文件http://dev.mysql.com/doc/refman/5.6/en/source-configuration-options.html,去除选项-DWITH_READLINE=1和-DWITH_SSL=YES

重新

cmake-DCMAKE_INSTALL_PREFIX=/usr/local/mysql-DMYSQL_DATADIR=/data/mysql-DDEFAULT_CHARSET=utf8-DDEFAULT_COLLATION=utf8_general_ci-DWITH_EXTRA_CHARSETS:STRING=all-DWITH_DEBUG=0-DENABLED_LOCAL_INFILE=1

出现warning:

--Runningcmakeversion2.8.12.2
--MySQL5.6.27
--Packagingas:mysql-5.6.27-Linux-x86_64
--HAVE_VISIBILITY_HIDDEN
--HAVE_VISIBILITY_HIDDEN
--HAVE_VISIBILITY_HIDDEN
--Usingcmakeversion2.8.12.2
--NotbuildingNDB
--LibrarymysqlclientdependsonOSLIBS-lpthread;m;rt;dl
Warning:BisonexecutablenotfoundinPATH
--LibrarymysqlserverdependsonOSLIBS-lpthread;m;rt;crypt;dl
--CMAKE_BUILD_TYPE:RelWithDebInfo
--COMPILE_DEFINITIONS:HAVE_CONFIG_H
--CMAKE_C_FLAGS:-Wall-Wextra-Wformat-security-Wvla-Wwrite-strings-Wdeclaration-after-statement
--CMAKE_CXX_FLAGS:-Wall-Wextra-Wformat-security-Wvla-Woverloaded-virtual-Wno-unused-parameter
--CMAKE_C_FLAGS_RELWITHDEBINFO:-O3-g-fabi-version=2-fno-omit-frame-pointer-fno-strict-aliasing-DDBUG_OFF
--CMAKE_CXX_FLAGS_RELWITHDEBINFO:-O3-g-fabi-version=2-fno-omit-frame-pointer-fno-strict-aliasing-DDBUG_OFF
--Configuringdone
--Generatingdone
--Buildfileshavebeenwrittento:/usr/local/src/mysql-5.6.27

分析:Warning: Bison executable not found in PATH 缺少Bison,yum install -y bison

cmake-DCMAKE_INSTALL_PREFIX=/usr/local/mysql-DMYSQL_DATADIR=/data/mysql-DDEFAULT_CHARSET=utf8-DDEFAULT_COLLATION=utf8_general_ci-DWITH_EXTRA_CHARSETS:STRING=all-DWITH_DEBUG=0-DENABLED_LOCAL_INFILE=1

echo $? 是0代表OK

9.make && make install

10.chown -R mysql:mysql /usr/local/mysql/

11.cd /usr/local/mysql/

12../scripts/mysql_install_db --user=mysql --datadir=/data/mysql 初始化

13.cp support-files/my-default.cnf /etc/my.cnf

14.cp support-files/mysql.server /etc/init.d/mysqld

15.chmod 755 /etc/init.d/mysqld

16.vim /etc/init.d/mysqld 修改datadir=/data/mysql

19.service mysqld start

成功启动Starting MySQL.. SU时间:2015-12-26 16:56:06 阅读:7429 评论:0 收藏:0标签:mysqlrunninglocalversion环境:centos6.5.x86_64

  1. wgethttp://mirrors.sohu.com/mysql/MySQL-5.6/mysql-5.6.27.tar.gz

  2. yum install -y cmake 当然也可以自己下载源码包安装,为方便就Yum安装了

  3. useradd -s /sbin/nologin mysql

  4. tar zxvf mysql-5.6.27.tar.gz

  5. mkdir -p /data/mysql

  6. chown -R mysql:mysql /data/mysql

  7. cd mysql-5.6.27

  8. cmake.-DCMAKE_INSTALL_PREFIX=/usr/local/mysql-DMYSQL_DATADIR=/mysql/data-DDEFAULT_CHARSET=utf8-DDEFAULT_COLLATION=utf8_general_ci-DWITH_EXTRA_CHARSETS:STRING=all-DWITH_DEBUG=0-DENABLED_LOCAL_INFILE=1
--Runningcmakeversion2.8.12.2
--CouldNOTfindGit(missing:GIT_EXECUTABLE)
--TheCcompileridentificationisunknown
--TheCXXcompileridentificationisunknown
CMakeError:yourCcompiler:"CMAKE_C_COMPILER-NOTFOUND"wasnotfound.PleasesetCMAKE_C_COMPILERtoavalidcompilerpathorname.
CMakeError:yourCXXcompiler:"CMAKE_CXX_COMPILER-NOTFOUND"wasnotfound.PleasesetCMAKE_CXX_COMPILERtoavalidcompilerpathorname.
CMakeErroratcmake/os/Linux.cmake:27(STRING):
stringsub-commandREPLACErequiresatleastfourarguments.
CallStack(mostrecentcallfirst):
CMakeLists.txt:149(INCLUDE)
CMakeErroratcmake/os/Linux.cmake:27(STRING):
stringsub-commandREPLACErequiresatleastfourarguments.
CallStack(mostrecentcallfirst):
CMakeLists.txt:149(INCLUDE)
--MySQL5.6.27
--Packagingas:mysql-5.6.27-Linux-i686
--CouldNOTfindThreads(missing:Threads_FOUND)
--CouldNOTfindThreads(missing:Threads_FOUND)
--Checkifthesystemisbigendian
--Searching16bitinteger
CMakeErrorat/usr/share/cmake/Modules/TestBigEndian.cmake:44(message):
nosuitabletypefound
CallStack(mostrecentcallfirst):
configure.cmake:628(TEST_BIG_ENDIAN)
CMakeLists.txt:398(INCLUDE)
--Configuringincomplete,errorsoccurred!
Seealso"/usr/local/src/mysql-5.6.27/CMakeFiles/CMakeOutput.log".
Seealso"/usr/local/src/mysql-5.6.27/CMakeFiles/CMakeError.log".

分析:

-- Could NOT find Git (missing: GIT_EXECUTABLE)这项应该缺少git包,yum install -y git

-- The C compiler identification is unknown

-- The CXX compiler identification is unknown 这两项缺少gcc和gcc-c++的包,yum install -y gcc gcc-c++

另外需要rmCMakeCache.txt

继续

cmake.-DCMAKE_INSTALL_PREFIX=/usr/local/mysql-DMYSQL_DATADIR=/mysql/data-DDEFAULT_CHARSET=utf8-DDEFAULT_COLLATION=utf8_general_ci-DWITH_EXTRA_CHARSETS:STRING=all-DWITH_DEBUG=0-DWITH_SSL=yes-DWITH_READLINE=1-DENABLED_LOCAL_INFILE=1

出现错误:

CMakeError:Thefollowingvariablesareusedinthisproject,buttheyaresettoNOTFOUND.
PleasesetthemormakesuretheyaresetandtestedcorrectlyintheCMakefiles:
OPENSSL_INCLUDE_DIR
usedasincludedirectoryindirectory/usr/local/src/mysql-5.6.27/CMakeFiles/CMakeTmp
CMakeError:InternalCMakeerror,TryCompileconfigureofcmakefailed
--Checksizeofwchar_t-failed
--Checksizeofwctype_t
CMakeError:Thefollowingvariablesareusedinthisproject,buttheyaresettoNOTFOUND.
PleasesetthemormakesuretheyaresetandtestedcorrectlyintheCMakefiles:
OPENSSL_INCLUDE_DIR
usedasincludedirectoryindirectory/usr/local/src/mysql-5.6.27/CMakeFiles/CMakeTmp
CMakeError:InternalCMakeerror,TryCompileconfigureofcmakefailed
--Checksizeofwctype_t-failed
--Checksizeofwint_t
CMakeError:Thefollowingvariablesareusedinthisproject,buttheyaresettoNOTFOUND.
PleasesetthemormakesuretheyaresetandtestedcorrectlyintheCMakefiles:
OPENSSL_INCLUDE_DIR
usedasincludedirectoryindirectory/usr/local/src/mysql-5.6.27/CMakeFiles/CMakeTmp
CMakeError:InternalCMakeerror,TryCompileconfigureofcmakefailed
--Checksizeofwint_t-failed
--CouldNOTfindCurses(missing:CURSES_LIBRARYCURSES_INCLUDE_PATH)
CMakeErroratcmake/readline.cmake:85(MESSAGE):
Curseslibrarynotfound.Pleaseinstallappropriatepackage,
removeCMakeCache.txtandreruncmake.OnDebian/Ubuntu,packagenameislibncurses5-dev,onRedhatandderivatesitisncurses-devel.
CallStack(mostrecentcallfirst):
cmake/readline.cmake:128(FIND_CURSES)
cmake/readline.cmake:202(MYSQL_USE_BUNDLED_EDITLINE)
CMakeLists.txt:409(MYSQL_CHECK_EDITLINE)
--Configuringincomplete,errorsoccurred!
Seealso"/usr/local/src/mysql-5.6.27/CMakeFiles/CMakeOutput.log".
Seealso"/usr/local/src/mysql-5.6.27/CMakeFiles/CMakeError.log".

分析:

--CouldNOTfindCurses(missing:CURSES_LIBRARYCURSES_INCLUDE_PATH)

缺少ncurses-devel包,yum install -yncurses-devel

rm CMakeCache.txt

通过阅读官方文件http://dev.mysql.com/doc/refman/5.6/en/source-configuration-options.html,去除选项-DWITH_READLINE=1和-DWITH_SSL=YES

重新

cmake-DCMAKE_INSTALL_PREFIX=/usr/local/mysql-DMYSQL_DATADIR=/data/mysql-DDEFAULT_CHARSET=utf8-DDEFAULT_COLLATION=utf8_general_ci-DWITH_EXTRA_CHARSETS:STRING=all-DWITH_DEBUG=0-DENABLED_LOCAL_INFILE=1

出现warning:

--Runningcmakeversion2.8.12.2
--MySQL5.6.27
--Packagingas:mysql-5.6.27-Linux-x86_64
--HAVE_VISIBILITY_HIDDEN
--HAVE_VISIBILITY_HIDDEN
--HAVE_VISIBILITY_HIDDEN
--Usingcmakeversion2.8.12.2
--NotbuildingNDB
--LibrarymysqlclientdependsonOSLIBS-lpthread;m;rt;dl
Warning:BisonexecutablenotfoundinPATH
--LibrarymysqlserverdependsonOSLIBS-lpthread;m;rt;crypt;dl
--CMAKE_BUILD_TYPE:RelWithDebInfo
--COMPILE_DEFINITIONS:HAVE_CONFIG_H
--CMAKE_C_FLAGS:-Wall-Wextra-Wformat-security-Wvla-Wwrite-strings-Wdeclaration-after-statement
--CMAKE_CXX_FLAGS:-Wall-Wextra-Wformat-security-Wvla-Woverloaded-virtual-Wno-unused-parameter
--CMAKE_C_FLAGS_RELWITHDEBINFO:-O3-g-fabi-version=2-fno-omit-frame-pointer-fno-strict-aliasing-DDBUG_OFF
--CMAKE_CXX_FLAGS_RELWITHDEBINFO:-O3-g-fabi-version=2-fno-omit-frame-pointer-fno-strict-aliasing-DDBUG_OFF
--Configuringdone
--Generatingdone
--Buildfileshavebeenwrittento:/usr/local/src/mysql-5.6.27

分析:Warning: Bison executable not found in PATH 缺少Bison,yum install -y bison

cmake-DCMAKE_INSTALL_PREFIX=/usr/local/mysql-DMYSQL_DATADIR=/data/mysql-DDEFAULT_CHARSET=utf8-DDEFAULT_COLLATION=utf8_general_ci-DWITH_EXTRA_CHARSETS:STRING=all-DWITH_DEBUG=0-DENABLED_LOCAL_INFILE=1

echo $? 是0代表OK

9.make && make install

10.chown -R mysql:mysql /usr/local/mysql/

11.cd /usr/local/mysql/

12../scripts/mysql_install_db --user=mysql --datadir=/data/mysql 初始化

13.cp support-files/my-default.cnf /etc/my.cnf

14.cp support-files/mysql.server /etc/init.d/mysqld

15.chmod 755 /etc/init.d/mysqld

16.vim /etc/init.d/mysqld 修改datadir=/data/mysql

19.service mysqld start

成功启动Starting MySQL.. SUCCESS!

免责声明:文章转载自《mysql-5.6.27源码安装及错误解决办法》仅用于学习参考。如对内容有疑问,请及时联系本站处理。

上篇iOS- CoreData 数据库管理利器!AlarmManager下篇

宿迁高防,2C2G15M,22元/月;香港BGP,2C5G5M,25元/月 雨云优惠码:MjYwNzM=

相关文章

C# HTTP请求 异步(async await)

static void Main(string[] args) { new Task(() => { Invoke(); }).Start(); Console.WriteLine("我是主线...

mysql设置连接等待时间(wait_timeout)

Linux下mysql修改连接超时   1,首先进入mysql,查看 wait_timeout、interactive_timeout这个值是否为默认的8小时(即 28800)  [root@server110 ~]# mysql -u root -p  Enter password:  输密码进入  执行如下命令  show variables like...

Java调用Http/Https接口(8,end)OkHttp调用Http/Https接口

OkHttp是一个高效的HTTP客户端,在Android中用的比较多,也可以用在Java中;本文主要介绍OkHttp在java中的使用,文中所使用到的软件版本:Java 1.8.0_191、SpringBoot2.2.1.RELEASE。 1、OkHttp特点 a、支持HTTP/2,允许所有同一个主机地址的请求共享同一个socket连接b、连接池减少请求延...

python爬取网易翻译 和MD5加密

一、程序需要知识 1、python中随机数的生成 #生成 0 ~ 9 之间的随机数 #导入 random(随机数) 模块 importrandom print(random.randint(0,9)) 2、python获取当前时间和时间戳 importtime,datetime #时间戳 print(time.time()) #今天的日期 prin...

Django 表操作-表之间的关系(建立在MySQL上)

Django 表操作-表之间的关系(建立在MySQL上) 数据表之间的关系有:一对多,多对多和一对一,在Django项目中做好建立表关系的准备 数据表:book,book_detail,author,publish 数据关系: 多对多:book和author 一对多:book和publish 一对一:book和book_detail 所有外键推荐建立在查询...

【笔记】SpringBoot+Shiro 实现简单权限管理(使用mysql数据库)

网上翻了好久 都没有SpringBoot+Shiro的入门教程 原本想看《跟我学Shiro》 然后发现这是从头开始 但是我就需要和SpringBoot整一块 不需要那么多的东西 感觉这个当参考书不错 于是东拼西凑终于整成了 把别人的教程上我用不到的都删了 该改的改 终于拿到了我理想中的效果 先是数据库部分 因为是简单的实现 就没有弄得太复杂 三部分 用户...