CentOS-6.3安装mysql-5.6.14

安装方式分为rpm和源码编译安装两种，本文是采用mysql源码编译方式，编译器使用Cmake。软件需要mysql-5.5.29.tar.gz和cmake-2.8.10.2.tar.gz，请自行下载。
下载地址：
http://mysql.mirror.kangaroot.net/Downloads/
http://www.cmake.org/files/v2.8/cmake-2.8.10.2.tar.gz

其中mysql使用最新的稳定版本，即最新试用版的上一个版本，且非rc或者alpha的版本，Cmake直接用的最新版。

1.上传mysql-5.6.14.tar.gz和cmake-2.8.10.2.tar.gz到/usr/local文件夹下。

2.CentOS安装g++和ncurses-devel

[root@localhost local]# yum install gcc-c++[root@localhost local]# yum install ncurses-devel

3.cmake的安装

[root@AY1403221420500563ebZ]# tar -zxv -f cmake-2.8.10.2.tar.gz // 解压压缩包[root@AY1403221420500563ebZ local]# cd cmake-2.8.10.2[root@AY1403221420500563ebZ cmake-2.8.10.2]# ./configure[root@AY1403221420500563ebZ cmake-2.8.10.2]# make[root@AY1403221420500563ebZ cmake-2.8.10.2]# make install

4.将cmake永久加入系统环境变量

[root@AY1403221420500563ebZ cmake-2.8.10.2]# vim /etc/profile

在文件末尾追加以下两行代码：
PATH=/usr/local/cmake-2.8.10.2/bin:$PATH
执行以下代码使刚才的修改生效：export PATH执行以下代码使刚才的修改生效：

[root@AY1403221420500563ebZ cmake-2.8.10.2]# source /etc/profile

用 export 命令查看PATH值

[root@AY1403221420500563ebZ local]# echo $PATH

5.创建mysql的安装目录及数据库存放目录

[root@AY1403221420500563ebZ local]# mkdir -p /usr/local/mysql //安装mysql[root@AY1403221420500563ebZ local]# mkdir -p /usr/local/mysql/data //存放数据库

6.创建mysql用户及用户组

[root@AY1403221420500563ebZ ] groupadd mysql
[root@AY1403221420500563ebZ ] useradd -r -g mysql mysql

7.编译安装mysql

[root@AY1403221420500563ebZ local]# tar -zxv -f mysql-5.6.14.tar.gz //解压
[root@AY1403221420500563ebZ local]# cd mysql-5.6.14
[root@AY1403221420500563ebZ mysql-5.6.14]#
cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql \
-DMYSQL_UNIX_ADDR=/usr/local/mysql/mysql.sock \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci \
-DWITH_MYISAM_STORAGE_ENGINE=1 \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_MEMORY_STORAGE_ENGINE=1 \
-DWITH_READLINE=1 \
-DENABLED_LOCAL_INFILE=1 \
-DMYSQL_DATADIR=/usr/local/mysql/data \
-DMYSQL_USER=mysql \
-DMYSQL_TCP_PORT=3306
[root@AY1403221420500563ebZ mysql-5.6.14]# make
[root@AY1403221420500563ebZ mysql-5.6.14]# make install

8.检验是否安装成功

[root@AY1403221420500563ebZ mysql-5.5.29]# cd /usr/local/mysql/[root@AY1403221420500563ebZ mysql]# lsbin COPYING data docs include INSTALL-BINARY lib man mysql-test README scripts share sql-bench support-files

有bin等以上文件的话，恭喜你已经成功安装了mysql。

9设置权限

使用下面的命令查看是否有mysql用户及用户组

cat /etc/passwd 查看用户列表cat /etc/group  查看用户组列表

如果没有就创建

groupadd mysqluseradd -g mysql mysql

修改/usr/local/mysql权限

chown -R mysql:mysql /usr/local/mysql

修改/usr/local/mysql权限

10初始化配置

进入安装路径

cd /usr/local/mysql

进入安装路径，执行初始化配置脚本，创建系统自带的数据库和表

scripts/mysql_install_db --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql

注意：/etc/my.cnf  的优先级要高于 /usr/local/mysql/my.cnf

原因：/etc/init.d/mysql  文件中conf一行定义，从/etc路径加载my.cnf文件

下面是我的my.cnf文件的配置（注意client中的pid-file参数，如果不注掉，会导致远程无法连接数据库）

# For advice on how to change settings please see# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html# *** DO NOT EDIT THIS FILE. It's a template which will be copied to the# *** default location during install, and will be replaced if you# *** upgrade to a newer version of MySQL.[client]socket = /usr/local/mysql/data/mysql.sock#pid-file = /usr/local/mysql/data/mysql.pid[mysqld]# Remove leading # and set to the amount of RAM for the most important data# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.innodb_buffer_pool_size = 28M# Remove leading # to turn on a very important data integrity option: logging# changes to the binary log between backups.# log_bin# These are commonly set, remove the # and set as required.basedir = /usr/local/mysqldatadir = /usr/local/mysql/dataport = 3306#server_id = .....socket = /usr/local/mysql/data/mysql.sockpid-file = /usr/local/mysql/data/mysql.pid# Remove leading # to set options mainly useful for reporting servers.# The server defaults are faster for transactions and fast SELECTs.# Adjust sizes as needed, experiment to find the optimal values.#join_buffer_size = 32M#sort_buffer_size = 2M#read_rnd_buffer_size = 2M explicit_defaults_for_timestamp = truesql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES [mysqld_safe]pid-file=/usr/local/mysql/datamysql.pid

11.将mysql的路径添加到PATH中

vim /etc/profile

PATH=$PATH:/usr/local/mysql/bin:/usr/local/mysql/lib

source /etc/profileecho $PATH 

12.修改MySQL的root用户的密码以及打开远程连接

添加服务，拷贝服务脚本到init.d目录，并设置开机启动

cd /usr/local/mysqlcp support-files/mysql.server /etc/init.d/mysqlchkconfig mysql onservice mysql start  --启动MySQL

13.修改MySQL的root用户的密码以及打开远程连接

[root@localhost mysql]# mysql -u root mysql

mysql> use mysql;
mysql> desc user;
mysql> GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY "root"; //为root添加远程连接的能力
mysql> update user set Password = password('123456') where User='root'; //设置root用户密码
mysql> select Host,User,Password from user where User='root';
mysql> flush privileges;
mysql> exit

   开启：         /etc/init.d/mysql start
   关闭：         /etc/init.d/mysql stop
   重启：         /etc/init.d/mysql restart

参考文章

http://www.cnblogs.com/xiongpq/p/3384681.html

http://www.cnblogs.com/zhoulf/archive/2013/01/25/zhoulf.html