MySQL 5.5源码安装

MySQL 5.5的安装方法和5.1略有 不同，主要区别在配置环境，MySQL 5.1的安装方法，参考搭建LAMP环境(源码方式)。本文讲解怎样在RedHat 6.1系统上安装MySQL 5.5.

首先，我们要准备MySQL，至于在什么地方下载，想必不用多说，这个可难不倒聪明的小伙伴们。本文使用的MySQL版本是5.5.29，假设读者已经把该版本或者5.5的其他版本准备好了，下面正式讲解怎样安装MySQL 5.5。本文的操作均在虚拟机下完成。

第一步，真实机拷贝MySQL 5.5源码包到虚拟机下

[root@serv01 ~]# yum install /usr/bin/scp -y[root@larrywen ule-mysql]# scpmysql-5.5.29.tar.gz 192.168.1.11:/optroot@192.168.1.11's password:mysql-5.5.29.tar.gz                                                                                100%   24MB  23.7MB/s  00:00

第二步，对源码进行编译需要make等命令，所以我们安装开发工具包

[root@serv01 ~]# yum grouplist | grep Devel  Additional Development  Desktop Platform Development  Development tools  Server Platform Development[root@serv01 ~]# yum groupinstall"Development tools" -y

 

第三步，解压源码包到/usr/src目录，/usr/src是建议命令

[root@serv01 opt]# tar -xvf mysql-5.5.29.tar.gz -C /usr/src/

第四步，进入MySQL的解压目录

[root@serv01 opt]# cd /usr/src/mysql-5.5.29/#安装帮助文档（可以参考这个文件进行安装）[root@serv01 mysql-5.5.29]# vim INSTALL-SOURCEshell> tar zxvf mysql-VERSION.tar.gzshell> cd mysql-VERSIONshell> cmake .shell> makeshell> make install# End of source-build specific instructions# Postinstallation setupshell> cd /usr/local/mysqlshell> chown -R mysql .shell> chgrp -R mysql .shell> scripts/mysql_install_db--user=mysqlshell> chown -R root .shell> chown -R mysql data# Next command is optionalshell> cp support-files/my-medium.cnf/etc/my.cnfshell> bin/mysqld_safe --user=mysql &# Next command is optionalshell> cp support-files/mysql.server/etc/init.d/mysql.server

 

第五步，因为配置环境需要使用到cmake，且MySQL依赖ncurses-devel包，所以我们安装cmake和ncurses-devel

[root@serv01 mysql-5.5.29]# yum install cmake-y[root@serv01 mysql-5.5.29]# yum install ncurses-devel -y

 

第六步，关键步骤，这一步也是和MySQL 5.1的不同之处，使用cmake命令配置环境，如下

[root@serv01 mysql-5.5.29]# cmake .  \-DCMAKE_INSTALL_PREFIX=/usr/local/mysql \-DWITH_INNOBASE_STORAGE_ENGINE=1  \-DWITH_MYISAM_STORAGE_ENGINE=1 \-DWITH_MEMORY_STORAGE_ENGINE=1 \-DDEFAULT_CHARSET=utf8  \-DDEFAULT_COLLATION=utf8_general_ci  \-DWITH_EXTRA_CHARSETS=all \-DMYSQL_TCP_PORT=3306  \-DMYSQL_UNIX_ADDR=/tmp/mysql.sock  \-DMYSQL_DATADIR=/usr/local/mysql/data解释：-DCMAKE_INSTALL_PREFIX=/usr/local/mysql：MySQL安装目录，推荐安装到此目录-DWITH_INNOBASE_STORAGE_ENGINE=1：安装InnoDB存储引擎-DWITH_MYISAM_STORAGE_ENGINE=1：安装MyISAM存储引擎-DWITH_MEMORY_STORAGE_ENGINE=1：安装内存存储引擎-DDEFAULT_CHARSET=utf8：默认编码设置成utf8-DDEFAULT_COLLATION=utf8_general_ci：默然校验规则是utf8_general_ci-DWITH_EXTRA_CHARSETS=all：支持其他所有的编码-DMYSQL_TCP_PORT=3306：MySQL端口指定为3306-DMYSQL_UNIX_ADDR=/tmp/mysql.sock：指定SOCK文件路径-DMYSQL_DATADIR=/usr/local/mysql/data：MySQL数据目录

第七步，编译安装

[root@serv01 mysql-5.5.29]# make && make install#确定安装目录存在[root@serv01 mysql-5.5.29]# ls/usr/local/mysql/bin COPYING  data  docs include  INSTALL-BINARY  lib man  mysql-test  README scripts  share  sql-bench support-files

第八步，添加mysql组和用户

[root@serv01 opt]# groupadd -g 500 mysql[root@serv01 opt]# useradd -u 500 -g 500 -r -M -s /sbin/nologin mysql 

第九步，拷贝配置文件和启动脚本，并修改启动脚本的执行权限

[root@serv01 mysql-5.5.29]# cpsupport-files/my-medium.cnf /etc/my.cnfcp: overwrite `/etc/my.cnf'? y[root@serv01 mysql-5.5.29]# cpsupport-files/mysql.server /etc/init.d/mysqld[root@serv01 mysql-5.5.29]# chmod a+x/etc/init.d/mysqld[root@serv01 mysql-5.5.29]# ls /usr/local/mysql/data/mysql test

第十步，改变mysql目录的拥有者和所属组，并修改my.cnf文件，添加data目录

[root@serv01 mysql-5.5.29]# chown mysql.mysql/usr/local/mysql/ -R[root@serv01 mysql-5.5.29]# vim /etc/my.cnf[root@serv01 mysql-5.5.29]# cat /etc/my.cnf |grep datadirdatadir         =/usr/local/mysql/data

第十一步，修改mysql_install_db的权限，使其可执行，并进行初始化操作

[root@serv01 mysql-5.5.29]# chmod a+xscripts/mysql_install_db[root@serv01 mysql-5.5.29]#./scripts/mysql_install_db --user=mysql --datadir=/usr/local/mysql/data/--basedir=/usr/local/mysql/WARNING: The host 'serv01.host.com' could notbe looked up with resolveip.This probably means that your libc librariesare not 100 % compatiblewith this binary MySQL version. The MySQLdaemon, mysqld, should worknormally with the exception that host nameresolving will not work.This means that you should use IP addressesinstead of hostnameswhen specifying MySQL privileges !Installing MySQL system tables...OKFilling help tables...OK To start mysqld at boot time you have to copysupport-files/mysql.server to the right placefor your system PLEASE REMEMBER TO SET A PASSWORD FOR THEMySQL root USER !To do so, start the server, then issue thefollowing commands: /usr/local/mysql//bin/mysqladmin -u rootpassword 'new-password'/usr/local/mysql//bin/mysqladmin -u root -hserv01.host.com password 'new-password' Alternatively you can run:/usr/local/mysql//bin/mysql_secure_installation which will also give you the option ofremoving the testdatabases and anonymous user created bydefault.  This isstrongly recommended for production servers. See the manual for more instructions. You can start the MySQL daemon with:cd /usr/local/mysql/ ;/usr/local/mysql//bin/mysqld_safe & You can test the MySQL daemon withmysql-test-run.plcd /usr/local/mysql//mysql-test ; perlmysql-test-run.pl Please report any problems with the/usr/local/mysql//scripts/mysqlbug script!

第十二步，启动MySQL，如果出现SUCCESS，恭喜您，MySQL启动成功；如果出错，不要着急，根据日志排查错误

[root@serv01 mysql-5.5.29]#/etc/init.d/mysqld startStarting MySQL.. SUCCESS![root@serv01 mysql-5.5.29]# ll/usr/local/mysql/data/ -ddrwxr-xr-x. 5 mysql mysql 4096 Sep  4 23:39 /usr/local/mysql/data/

第十三步，添加环境变量，并使其生效

[root@serv01 mysql-5.5.29]# vim~/.bash_profile[root@serv01 mysql-5.5.29]# . !$. ~/.bash_profile[root@serv01 mysql-5.5.29]# cat ~/.bash_profile| grep PATHPATH=/usr/local/mysql/bin/:$PATH:$HOME/binexport PATH

第十四步，登录mysql，查看版本，如果出现版本号，则证明安装成功

[root@serv01 mysql-5.5.29]# mysqlWelcome to the MySQL monitor.  Commands end with ; or \g.Your MySQL connection id is 1Server version: 5.5.29-log Sourcedistribution Copyright (c) 2000, 2012, Oracle and/or itsaffiliates. All rights reserved. Oracle is a registered trademark of OracleCorporation and/or itsaffiliates. Other names may be trademarks oftheir respectiveowners. Type 'help;' or '\h' for help. Type '\c' toclear the current input statement. mysql> select version();+------------+| version() |+------------+| 5.5.29-log |+------------+1 row in set (0.00 sec) mysql> exitBye

如果需要安装多个MySQL，需要修改端口，修改sock文件

[root@serv01 mysql-5.5.29]# cat /etc/my.cnf |grep -e sock -e portport              =3306socket           =/tmp/mysql.sock

  我的邮箱：[e-mail]  新浪微博：@Wentasy27           微信公众平台：JustOracle（微信号：justoracle）  数据库技术交流群：336882565（加群时验证 From CSDN XXX）  All is well  2013年10月20日  By Larry Wen

 @Wentasy 博文仅供参考，欢迎大家来访。如有错误之处，希望批评指正。原创博文如需转载请注明出处，谢谢 :) [CSDN博客]