Mysql源码安装
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