Redhat下的Mysql源码安装

Installing MySQL on Linux Using the MySQL Yum Repository

如果选择使用yum安装5.6版本

Enable to use MySQL 5.6
[mysql56-community]
name=MySQL 5.6 Community Server
baseurl=http://repo.mysql.com/yum/mysql-5.6-community/el/6/$basearch/
enabled=1
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql

shell> sudo yum install mysql-community-server

源码安装

Source Installation System Requirements

• CMake, which is used as the build framework on all platforms
• GNU make 3.75 or higher
• A working ANSI C++ compiler. GCC 4.2.1 or later
• erl is needed if you intend to run test scripts

How to Get MySQL

选择自己的系统进行下载 ，直接下载.tar.gz源码
http://cdn.mysql.com//Downloads/MySQL-5.6/mysql-5.6.31-linux-glibc2.5-x86_64.tar.gz

解压后的文件目录架构如下所示：
Directory Contents of Directory
bin, scripts mysqld server, client and utility programs
data Log files, databases
docs MySQL manual in Info format
man Unix manual pages
include Include (header) files
lib Libraries
share Miscellaneous support files, including error messages, sample configuration files, SQL for database installation
sql-bench Benchmarks

开始安装

建立用户，解压文件
shell> groupadd mysql
shell> useradd -g mysql mysql
shell> cd /usr/local
shell> tar zxvf /path/to/mysql-VERSION-OS.tar.gz
shell> ln -s full-path-to-mysql-VERSION-OS mysql
shell> cd mysql
shell> chown -R mysql .
shell> chgrp -R mysql .

自定义数据文件的保存文件
shell> mkdir -p /data/mysql

初始化mysql,basedir 是解压安装文件的目录
shell>/script/mysql_install_db –user=mysql –basedir=/usr/local/mysql/ –datadir=/data/mysql/

修改配置文件 ，并建立配置文件短链接
vi /usr/local/mysql/my.cnf
basedir = /usr/local/mysql
datadir = /data/mysql
ln -s /usr/local/mysql/my.cnf /etc/my.cnf

shell> cp support-files/mysql.server /etc/init.d/mysqld 将常用启动服务放到/etc/init文件中

增加环境变量
vi /etc/profile
export PATH=$PATH:/usr/local/mysql/bin
source /etc/profile 立即生效配置

service mysqld start 启动mysql程序

添加自动启动
chkconfig –add mysqld
chkconfig mysqld on

Mysql启动成功