编译安装mysql5.7版本，想试用一下新的版本特性，发现跟之前的5.6版本编译有了一些变化，总结一下避免以后继续入坑。5.6安装方式

cmake版本

5.7编译cmake要求版本最低为2.8，当前为2.6，所以需要升级cmake版本。信息如下

shell>cmake.-DCMAKE_INSTALL_PREFIX=/db/mysql/mysql_57-DMYSQL_DATADIR=/db/mysql/mysql_57/dataCMakeErroratCMakeLists.txt:21(CMAKE_MINIMUM_REQUIRED):CMake2.8.2orhigherisrequired.Youarerunningversion2.6.4--Configuringincomplete,errorsoccurred!shell>cmake--versioncmakeversion2.6-patch4

cmake官网下载地址

shell>tarzxvfcmake-3.2.2.tar.gzshell>cdcmake-3.2.2/shell>./bootstrapshell>make&&makeinstallshell>cmake--versioncmakeversion3.2.2

BOOST库

5.7编译需要boost类库，可使用-DDOWNLOAD_BOOST=1 -DWITH_BOOST=参数将在指定路径查找，如未找到会指

定下载并解压到指定的路径

问题描述shell>cmake.-DCMAKE_INSTALL_PREFIX=/db/mysql/mysql_57-DMYSQL_DATADIR=/db/mysql/mysql_57/dataCMakesuitemaintainedandsupportedbyKitware(kitware.com/cmake).--Couldnotfind(thecorrectversionof)boost.--MySQLcurrentlyrequiresboost_1_57_0CMakeErroratcmake/boost.cmake:76(MESSAGE):Youcandownloaditwith-DDOWNLOAD_BOOST=1-DWITH_BOOST=安装boost库shell>tarjxvfboost_1_57_0.tar.bz2shell>cdboost_1_57_0/shell>./bootstrap.shshell>./b2install安装后目录shell>ls/usr/local/include/boostshell>cmake.-DCMAKE_INSTALL_PREFIX=/db/mysql/mysql_57-DMYSQL_DATADIR=/db/mysql/mysql_57/data

mysql_install_db

之前版本mysql_install_db是在mysql_basedir/script下，5.7放在了mysql_install_db/bin目录下,且已被废弃。

shell>cd/db/mysql/mysql_57shell>bin/mysql_install_db--basedir=.--datadir=data--user=mysql[WARNING]mysql_install_dbisdeprecated.Pleaseconsiderswitchingtomysqld--initializeshell>bin/mysqld--initialize2015-04-21T18:17:53.169216Z0[Warning]TIMESTAMPwithimplicitDEFAULTvalueisdeprecated.Pleaseuse--explicit_defaults_for_timestampserveroption(seedocumentationformoredetails).2015-04-21T18:17:58.702510Z0[Warning]InnoDB:Newlogfilescreated,LSN=457902015-04-21T18:17:59.538811Z0[Warning]InnoDB:Creatingforeignkeyconstraintsystemtables.2015-04-21T18:17:59.646010Z0[Warning]FailedtosetupSSL2015-04-21T18:17:59.646105Z0[Warning]SSLerror:SSLcontextisnotusablewithoutcertificateandprivatekey2015-04-21T18:17:59.663795Z1[Warning]Atemporarypasswordisgeneratedforroot@localhost:rq/Oh8VWs1Yh

mysql5.7的数据库初始化如下：




shell>/usr/local/mysql/bin/mysqld--initialize--user=mysql--basedir=/usr/local/mysql/--datadir=/usr/local/mysql/data/

初始化密码

mysql5.7会生成一个初始化密码，而在之前的版本首次登陆不需要登录。

shell>cat/root/.mysql_secret#Passwordsetforuser'root@localhost'at2015-04-2222:13:23?G5W&tz1z.cN修改默认密码shell>bin/mysqladmin-hlocalhost-urootpassword'123@qwe'-p'?G5W&tz1z.cN'mysqladmin:[Warning]Usingapasswordonthecommandlineinterfacecanbeinsecure.Warning:Sincepasswordwillbesenttoserverinplaintext,usesslconnectiontoensurepasswordsafety.

另外mysql5.7的mysql.user表结构被修改

修改mysql.user方式修改密码mysql>updatemysql.usersetauthentication_string=password('123qwe')whereuser='svoid'andHost='localhost';QueryOK,1rowaffected(0.01sec)Rowsmatched:1Changed:1Warnings:0mysql>flushprivileges;QueryOK,0rowsaffected(0.00sec)

整理自：http://blog.itpub.net/29733787/viewspace-1590891/