SUSE Linux下源码编译方式安装MySQL 5.6过程分享

2024-04-08 07:42:03 30

MySQL为开源数据库，因此可以基于源码实现安装。基于源码安装有更多的灵活性。也就是说我们可以针对自己的硬件平台选用合适的编译器来优化编译后的二进制代码，根据不同的软件平台环境调整相关的编译参数，选择自身需要选择不同的安装组件，设定需要的字符集等等一些可以根据特定应用场景所作的各种调整。本文描述了如何在源码方式下安装MySQL。

1、安装环境及介质


#安装环境

SZDB:~#cat/etc/issue

WelcometoSUSELinuxEnterpriseServer10SP3(x86_64)-Kernel\r(\l).

SZDB:~#uname-a

LinuxSZDB2.6.16.60-0.54.5-smp#1SMPFriSep401:28:03UTC2009x86_64x86_64x86_64GNU/Linux

#安装介质，可以到以下网址下载安装介质，注意下载时选择sourcecode，当前版本为5.6.17

#根据你自身的环境下载相应的安装介质，本文演示的安装介质为GenericLinux(ArchitectureIndependent),mysql-5.6.17.tar.gz

http://dev.mysql.com/downloads/mysql/

#源码安装方式官方网站链接:http://dev.mysql.com/doc/refman/5.6/en/installing-source-distribution.html

2、系统需求


SourceInstallationSystemRequirements

 InstallationofMySQLfromsourcerequiresseveraldevelopmenttools.Someofthesetoolsareneedednomatterwhetheryouuseastandardsourcedistributionoradevelopmentsourcetree.Othertoolrequirementsdependonwhichinstallationmethodyouuse.

ToinstallMySQLfromsource,yoursystemmusthavethefollowingtools,regardlessofinstallationmethod:

CMake,whichisusedasthebuildframeworkonallplatforms.CMakecanbedownloadedfromhttp://www.cmake.org.

Agoodmakeprogram.Althoughsomeplatformscomewiththeirownmakeimplementations,itishighlyrecommendedthatyouuseGNUmake3.75ornewer.Itmayalreadybeavailableonyoursystemasgmake.GNUmakeisavailablefromhttp://www.gnu.org/software/make/.

AworkingANSIC++compiler.GCC4.2.1orlater,SunStudio12orlater,VisualStudio2010orlater,andmanycurrentvendor-suppliedcompilersareknowntowork.

Perlisneededifyouintendtoruntestscripts.MostUnix-likesystemsincludePerl.OnWindows,youcanuseaversionsuchasActiveStatePerl.

#使用源码安装上面的一些开发工具是需要的，比较重要的一个是Cmake工具，通常情况下os并没有安装，需要手动安装。

#如果没有cmake会收到这个错误提示：(-bash:cmake:commandnotfound)

3、安装cmake


#可以到这里下载cmake，我这里下载的是2.6.4版本

http://www.cmake.org/cmake/resources/software.html

SZDB:~#cd/usr/local/src/mysql_src

SZDB:/usr/local/src/mysql_src#tar-xvfcmake-2.6.4.tar.gz

SZDB:/usr/local/src/mysql_src#cdcmake-2.6.4

SZDB:/usr/local/src/mysql_src/cmake-2.6.4#./bootstrap 

SZDB:/usr/local/src/mysql_src/cmake-2.6.4#./make

SZDB:/usr/local/src/mysql_src/cmake-2.6.4#./makeinstall

4、安装MySQL


SZDB:~#groupaddmysql

SZDB:~#useradd-r-gmysqlmysql

SZDB:~#cd/usr/local/src/mysql_src

SZDB:/usr/local/src/mysql_src#tar-xvfmysql-5.6.17.tar.gz

SZDB:/usr/local/src/mysql_src#ls

mysql-5.6.17 mysql-5.6.17.tar.gz

SZDB:/usr/local/src/mysql_src#cdmysql-5.6.17/

SZDB:/usr/local/src/mysql_src/mysql-5.6.17#cmake.

            ..........

 --Checksizeofwint_t-done

 --CouldNOTfindCurses (missing: CURSES_LIBRARYCURSES_INCLUDE_PATH)

 CMakeErroratcmake/readline.cmake:85(MESSAGE):                Author:Leshami

   Curseslibrarynotfound. Pleaseinstallappropriatepackage, Blog  :http://blog.csdn.net/leshami

   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:411(MYSQL_CHECK_EDITLINE)

#如果cmake期间碰到上述错误，应该安装ncurses-develrpm包，然后移除CMakeCache.txt

--Configuringincomplete,errorsoccurred!

#如有没有对应的os安装光盘，可以从下面的链接下载这个rpm包，注意对应的版本号应一致

http://www.filewatcher.com/m/ncurses-devel-5.5-18.11.x86_64.rpm.735840-0.html

SZDB:/usr/local/src/mysql_src#rpm-Uvhncurses-devel-5.5-18.11.x86_64.rpm

Preparing...               ###########################################[100%]

  1:ncurses-devel         ###########################################[100%]

SZDB:/usr/local/src/mysql_src/mysql-5.6.17#rm-rfCMakeCache.txt

SZDB:/usr/local/src/mysql_src/mysql-5.6.17#cmake.     #再次执行cmake

             

                ........

  --LibrarymysqlserverdependsonOSLIBS-lpthread;m;rt;crypt;dl;aio

  --Configuringdone

  --Generatingdone

  --Buildfileshavebeenwrittento:/usr/local/src/mysql_src/mysql-5.6.17

SZDB:/usr/local/src/mysql_src/mysql-5.6.17#make

  LinkingCXXexecutablemysqltest_embedded

  [100%]Builttargetmysqltest_embedded

  Scanningdependenciesoftargetmy_safe_process

  [100%]BuildingCXXobjectmysql-test/lib/My/SafeProcess/CMakeFiles/my_safe_process.dir/safe_process.cc.o

  LinkingCXXexecutablemy_safe_process

  [100%]Builttargetmy_safe_process

SZDB:/usr/local/src/mysql_src/mysql-5.6.17#makeinstall

SZDB:/usr/local/src/mysql_src/mysql-5.6.17#cd/usr/local/mysql

SZDB:/usr/local/mysql#chown-Rmysql.

SZDB:/usr/local/mysql#chgrp-Rmysql.

SZDB:/usr/local/mysql#scripts/mysql_install_db--user=mysql

                   ..........

   Tostartmysqldatboottimeyouhavetocopy

   support-files/mysql.servertotherightplaceforyoursystem

   

   PLEASEREMEMBERTOSETAPASSWORDFORTHEMySQLrootUSER!

   Todoso,starttheserver,thenissuethefollowingcommands:

   

     ./bin/mysqladmin-urootpassword'new-password'

     ./bin/mysqladmin-uroot-hSZDBpassword'new-password'

   

   Alternativelyyoucanrun:

   

     ./bin/mysql_secure_installation

   

   whichwillalsogiveyoutheoptionofremovingthetest

   databasesandanonymoususercreatedbydefault. Thisis

   stronglyrecommendedforproductionservers.

   

   Seethemanualformoreinstructions.

   

   YoucanstarttheMySQLdaemonwith:

   

     cd.;./bin/mysqld_safe&

   

   YoucantesttheMySQLdaemonwithmysql-test-run.pl

   

     cdmysql-test;perlmysql-test-run.pl

  

   Newdefaultconfigfilewascreatedas./my.cnfand

   willbeusedbydefaultbytheserverwhenyoustartit.

   Youmayeditthisfiletochangeserversettings

        ..........

SZDB:/usr/local/mysql#chown-Rroot.

SZDB:/usr/local/mysql#chown-Rmysqldata    

SZDB:/usr/local/mysql#cpsupport-files/mysql.server/etc/init.d/mysql.server #配置自启动

SZDB:/usr/local/mysql#cpsupport-files/my-default.cnf/etc/my.cnf            #添加缺省的my.cnf配置文件 

SZDB:/usr/local/mysql#bin/mysqld_safe--user=mysql&                         #启动mysql

[1]21004

SZDB:/usr/local/mysql#14052102:54:54mysqld_safeLoggingto'/usr/local/mysql/data/SZDB.err'.

14052102:54:54mysqld_safeStartingmysqlddaemonwithdatabasesfrom/usr/local/mysql/data

#配置环境变量，通过软链或者修改环境变量实现(PATH=$PATH:/usr/local/mysql/bin/;exportPATH)

 

SZDB:~#ln-fs/usr/local/mysql/bin/mysql/usr/local/bin 

SZDB:~#ln-fs/usr/local/mysql/bin/mysqladmin/usr/local/bin 

SZDB:~#ln-fs/usr/local/mysql/bin/mysqld_safe/usr/local/bin

#登陆到mysql

SZDB:/usr/local/bin#mysql-uroot

WelcometotheMySQLmonitor. Commandsendwith;or\g.

YourMySQLconnectionidis1

Serverversion:5.6.17Sourcedistribution

Copyright(c)2000,2014,Oracleand/oritsaffiliates.Allrightsreserved.

OracleisaregisteredtrademarkofOracleCorporationand/orits

affiliates.Othernamesmaybetrademarksoftheirrespective

owners.

Type'help;'or'\h'forhelp.Type'\c'toclearthecurrentinputstatement.

mysql>showdatabases;

+--------------------+

|Database          |

+--------------------+

|information_schema|

|mysql             |

|performance_schema|

|test              |

+--------------------+

4rowsinset(0.00sec)

SUSE Linux下源码编译方式安装MySQL 5.6过程分享

热门推荐

随机推荐