Centos5.5中安装Mysql5.5过程分享
这几天在centos下装mysql,这里记录一下安装的过程,方便以后查阅
Mysql5.5.37安装需要cmake,5.6版本开始都需要cmake来编译,5.5以后的版本应该也要装这个。
安装cmake
[root@local~]#wgethttp://www.cmake.org/files/v2.8/cmake-2.8.12.2.tar.gz [root@local~]#tarxvfcmake-2.8.12.2.tar.gz [root@local~]#cdcmake-2.8.12.2 [root@localcmake-2.8.12.2]#./bootstrap [root@localcmake-2.8.12.2]#make [root@localcmake-2.8.12.2]#makeinstall
安装mysql
[root@local~]#wgethttp://cdn.mysql.com/Downloads/MySQL-5.5/mysql-5.5.37.tar.gz [root@local~]#tarxvfmysql-5.5.37.tar.gz [root@local~]#cdmysql-5.5.37 [root@localmysql-5.5.37]#cmake./
可能还会报这个错,没有就跳过
CMakeErroratcmake/readline.cmake:83(MESSAGE): Curseslibrarynotfound. Pleaseinstallappropriatepackage, removeCMakeCache.txtandreruncmake.OnDebian/Ubuntu,packagenameislibncurses5-dev,onRedhatandderivatesitisncurses-devel. CallStack(mostrecentcallfirst): cmake/readline.cmake:127(FIND_CURSES) cmake/readline.cmake:217(MYSQL_USE_BUNDLED_LIBEDIT) CMakeLists.txt:355(MYSQL_CHECK_READLINE --Configuringincomplete,errorsoccurred! Seealso"/root/my/mysql-5.5.37/CMakeFiles/CMakeOutput.log". Seealso"/root/my/mysql-5.5.37/CMakeFiles/CMakeError.log".
说明centos系统没有ncurses-devel
[root@local~]#wgethttp://invisible-island.net/datafiles/release/ncurses.tar.gz [root@local~]#cdncurses-5.9 [root@localncurses-5.9]#./configure [root@localncurses-5.9]#make [root@localncurses-5.9]#makeinstall
再删除刚才编译生成的CMakeCache.txt文件,否则无法进行下一步
[root@localmysql-5.5.37]#rm-fCMakeCache.txt
继续编译mysql
[root@local~]#cmake./ [root@local~]#make [root@local~]#makeinstall
这样,mysql默认将成功安装到/usr/local/mysql
创建mysql用户组
[root@local~]#groupaddmysql [root@local~]#useradd–r–gmysqlmysql [root@local~]#chown–Rmysql.mysql/usr/local/mysql
启动mysql
[root@local~]#/usr/local/mysql/bin/mysqld_safe--user=mysql
这里可能会发生错误,没有就跳过:
FATALERROR:Couldnotfind./bin/my_print_defaults Ifyoucompiledfromsource,youneedtorun'makeinstall'to copythesoftwareintothecorrectlocationreadyforoperation. Ifyouareusingabinaryrelease,youmusteitherbeatthetop leveloftheextractedarchive,orpassthe--basediroption pointingtothatlocation.
解决方法:
[root@local~]#/usr/local/mysql/scripts/mysql_install_db--user=mysql--basedir=/usr/local/mysql--datadir=/usr/local/mysql/data
再启动mysql
[root@local~]#/usr/local/mysql/bin/mysqld_safe--user=mysql
注册mysql服务,开机自动启动
1.设置mysql配置文件到/etc目录
[root@local~]#cp/usr/local/mysql/support-files/my-medium.cnf/etc/my.cnf
2.设置mysql开机自启
[root@local~]#cp/usr/local/mysql/support-files/mysql.server/etc/init.d/mysql [root@local~]#chmod+x/etc/init.d/mysql [root@local~]#/sbin/chkconfig--addmysql
3.启动mysql服务
[root@local~]#servicemysqlstart
测试mysql是否安装成功
[root@local~]#/usr/local/mysql/bin/mysql-uroot-p Enterpassword: WelcometotheMySQLmonitor. Commandsendwith;or\g. YourMySQLconnectionidis1 Serverversion:5.5.37Sourcedistribution 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.03sec)