CentOS6.x安装mysql5.6.x

1、系统及安装说明

系统：CentOS6.x_x64

mysql:社区版5.6.21,开源数据库用的最多的mysql，编译安装比较繁琐，yum安装版本比较低且默认安装的位置是/var/下，本次采用官方下载的rpm包，通过脚本自动化安装并定制数据目录到独立分区中(本次为/data目录)

2、准备安装包

1>官方下载

#https://dev.mysql.com/downloads/mysql/5.6.html#downloads 选择对应的版本和平台软件包：

MySQL-shared-compat-5.6.x-1.el6.x86_64.rpm #x就是你下的版本号以下类同
MySQL-devel-5.6.x-1.el6.x86_64.rpm
MySQL-shared-5.6.x-1.el6.x86_64.rpm
MySQL-client-5.6.x-1.el6.x86_64.rpm
MySQL-test-5.6.x-1.el6.x86_64.rpm
MySQL-server-5.6.x-1.el6.x86_64.rpm

2>本实验用到的包

https://pan.baidu.com/s/1kVraS8R 密码: iybx

包含了以下软件包：

MySQL-shared-compat-5.6.21-1.el6.x86_64.rpm
MySQL-devel-5.6.21-1.el6.x86_64.rpm
MySQL-shared-5.6.21-1.el6.x86_64.rpm
MySQL-client-5.6.21-1.el6.x86_64.rpm
MySQL-test-5.6.21-1.el6.x86_64.rpm
MySQL-server-5.6.21-1.el6.x86_64.rpm

2>mysql数据库默认的一些主要目录：

1、数据库目录　/var/lib/mysql/

2、配置文件　　/usr/share/mysql（mysql.server命令及配置文件）

3、相关命令　　/usr/bin (mysqladmin mysqldump等命令)

4、启动脚本　　/etc/rc.d/init.d/（启动脚本文件mysql的目录）

5、修改配置文件位置 cp /usr/share/mysql/my-default.cnf /etc/my.cnf

3、安装

1>如果是官方下载的请直接执行下面操作

#rpm -ivh MySQL-shared-compat-5.6.x-1.el6.x86_64.rpm       #提供基础依赖组件，需要第一个安装 #yum remove mysql-libs -y              #御载默认自带的mysql-lib#yum install libaio -y                         #安装libiao#rpm -ivh MySQL-devel-5.6.x-1.el6.x86_64.rpm#rpm -ivh MySQL-shared-5.6.x-1.el6.x86_64.rpm#rpm -ivh MySQL-client-5.6.x-1.el6.x86_64.rpm#rpm -ivh MySQL-test-5.6.x-1.el6.x86_64.rpm#rpm -ivh MySQL-server-5.6.x-1.el6.x86_64.rpm

因此可通过脚本重新初始化安装到别的目录;完成自定制;

2>脚本执行

#!/bin/bashsrc_dir=$(pwd)cd $src_dirtar xvf mysql5.6.21.x86_64.rpms.tar.gztar xvf mysql5.6.21.x86_64.rpms.tarcd mysql5.6.21rpm -ivh MySQL-shared-compat-5.6.21-1.el6.x86_64.rpmyum remove mysql-libs -yyum install libaio -yrpm -ivh MySQL-devel-5.6.21-1.el6.x86_64.rpmrpm -ivh MySQL-shared-5.6.21-1.el6.x86_64.rpmrpm -ivh MySQL-client-5.6.21-1.el6.x86_64.rpmrpm -ivh MySQL-test-5.6.21-1.el6.x86_64.rpmrpm -ivh MySQL-server-5.6.21-1.el6.x86_64.rpm #service mysql start && echo "mysql5.6.21 has installes sucess!"#mysql_root_pwd=`gawk -F : '{ print $4 }' /root/.mysql_secret`#echo "A random root password has been set. You will find it in '/root/.mysql_secret'."#echo "The random root password was:'${mysql_root_pwd// }'" service mysql stop[ -d /data/mysqldb/data ] || mkdir -p /data/mysqldb/data[ -d /data/mysqldb/log ] || mkdir -p /data/mysqldb/logchown mysql.mysql /data/mysqldb -Rcd /usr/bin./mysql_install_db --user=mysql --basedir=/usr --datadir=/data/mysqldb/data   #迁移数据目录到/data/mysqldb/data下可自行定制cd $src_dir cp ${src_dir}/my.cnf /etccd /var/libmv mysql /tmpmkdir mysqlchown mysql.mysql mysql service mysql start && echo "Mysql root password was empty.Please change when you login mysql."ln -s /data/mysqldb/data/mysql.sock   /var/lib/mysql/mysql.sock       #由于一些mysql工具默认到这里找mysql.sock所以做个软链

mysqladmin -u root password "123456"