mysql5.6.30源码安装_mysql5.6源码安装&&多实例安装

说明：

操作系统：CentOS 6.6 64位

MySQL版本：mysql-5.6.24

MySQL安装目录：/opt/mysql55

MySQL数据库存放目录：/opt/mysql55/data

1、下载MySQL

http://cdn.mysql.com/Downloads/MySQL-5.6/mysql-5.6.24.tar.gz

2、安装编译工具及库文件(使用CentOS yum命令安装，安装的比较多，方便以后编译安装php、nginx等)

yum install cmake autoconf automake curl curl-devel gcc gcc-c++ gtk+-devel zlib-devel openssl openssl-devel pcre-devel  perlkernel-headers compat*  cpp glibc libgomp libstdc++-devel keyutils-libs-devel libsepol-devel libselinux-devel krb5-devellibXpm* freetype freetype-devel freetype* fontconfig fontconfig-devel   libpng*    ncurses* libtool* libxml2 libxml2-develbison -y

3、安装MySQL

groupadd mysql #添加mysql组

useradd -g mysql mysql #创建用户mysql并加入到mysql组

mkdir -p /opt/mysql55 #创建MySQL安装目录

cd /usr/local/src #进入软件包存放目录

tar zxvf mysql-5.6.24.tar.gz #解压

cd mysql-5.6.24 #进入目录

***********************************补充************************************

4、编译参数简介

cmake \

-DCMAKE_INSTALL_PREFIX=/opt/mysql55 \                #设置安装目录

-DMYSQL_DATADIR=/opt/mysql55/data \                #设置数据库存放目录

-DSYSCONFDIR=/etc \        #设置my.cnf所在目录，默认为安装目录

-DWITH_MYISAM_STORAGE_ENGINE=1 \#添加MYISAM引擎支持

-DWITH_INNOBASE_STORAGE_ENGINE=1 \#添加InnoDB引擎支持

-DWITH_MEMORY_STORAGE_ENGINE=1 \#添加MEMORY支持

-DWITH_PARTITION_STORAGE_ENGINE=1 \#添加PARTITION支持

-DWITH_READLINE=1 \#加载readline库

-DMYSQL_UNIX_ADDR=/var/lib/mysql/mysql.sock \                #设置UNIX socket 目录

-DMYSQL_TCP_PORT=3306 \#设置服务器监听端口，默认3306

-DENABLED_LOCAL_INFILE=1 \#允许从本地导入数据

-DEXTRA_CHARSETS=all \#安装所有扩展字符集

-DDEFAULT_CHARSET=utf8 \#设置默认字符集，默认latin1

-DDEFAULT_COLLATION=utf8_general_ci#设置默认校对规则，默认latin1_general_ci

***************************************************************************

#配置

cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/usr/local/mysql/data -DSYSCONFDIR=/etc -

DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_MEMORY_STORAGE_ENGINE=1 -DWITH_READLINE=1 -

DMYSQL_UNIX_ADDR=/var/lib/mysql/mysql.sock -DMYSQL_TCP_PORT=3306 -DENABLED_LOCAL_INFILE=1 -DWITH_PARTITION_STORAGE_ENGINE=1-DEXTRA_CHARSETS=all -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci

#更多编译的参数可以参考

#http://dev.mysql.com/doc/refman/5.5/en/source-configuration-options.html

#http://dev.mysql.com/doc/refman/5.6/en/source-configuration-options.html

#编译

make

#安装

make install

cd /opt/mysql55         #进入MySQL安装目录

./scripts/mysql_install_db --user=mysql --basedir=/u01/mysql --datadir=/u01/mysql/data/  #初始化，生成msql系统数据库

cp ./support-files/mysql.server  /etc/init.d/mysqld          #把Mysql加入系统服务

chmod 755 /etc/init.d/mysqld   #增加执行权限

chkconfig mysqld on  #加入开机启动

service mysqld start  #启动

=======

可能会启动失败：Starting MySQL. ERROR! The server quit without updating PID file (/var/lib/mysql/mysql.top.pid).

1、/u01/mysql 目录的权限 改成mysql

chown -R mysql:mysql /u01/mysql/

2、

rpm -qa | grep -i mysql

rpm -e mysql-libs --nodeps

==========================

#把mysql服务加入系统环境变量：在最后添加下面这一行

vim /etc/profile

export PATH=$PATH:/u01/mysql/bin

mysqladmin -u root -p password "123456"   #或者直接修改密码

service mysqld restart    #重启

*******************************************************************

MySQL多实例安装

*******************************************************************

#建立data2、data3

[root@www mysql55]# pwd

/opt/mysql55

[root@www mysql55]# ll

total 196

drwxr-xr-x   2 root  root    4096 Apr 27 04:48 bin

-rw-r--r--   1 root  root   17987 Mar 26 00:34 COPYING

drwxr-xr-x.  5 mysql mysql   4096 Apr 27 08:55 data

drwxr-xr-x   5 mysql mysql   4096 Apr 27 08:20 data2

drwxr-xr-x   5 mysql mysql   4096 Apr 27 08:25 data3

#初始化，生成mysql系统数据库

./scripts/mysql_install_db --user=mysql --basedir=/opt/mysql55 --datadir=/opt/mysql55/data2

./scripts/mysql_install_db --user=mysql --basedir=/opt/mysql55 --datadir=/opt/mysql55/data3

#修改my.cnf

[mysqld_multi]

mysqld     =/opt/mysql55/bin/mysqld_safe

mysqladmin =/opt/mysql55/bin/mysqladmin

user       =test

password   =test

[mysqld3306]

basedir = /opt/mysql55

datadir = /opt/mysql55/data

port = 3306

pid-file=/tmp/mysql3306.pid

server-id=1

socket = /tmp/mysql3306.sock

[mysqld3307]

basedir = /opt/mysql55

datadir = /opt/mysql55/data2

port = 3307

pid-file=/tmp/mysql3307.pid

server-id=1

socket = /tmp/mysql3307.sock

[mysqld3308]

basedir = /opt/mysql55

datadir = /opt/mysql55/data3

port = 3308

pid-file=/tmp/mysql3308.pid

server-id=1

socket= /tmp/mysql3308.sock

[client]

port           =3306

socket         =/tmp/mysql.sock

# 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 = 128M

# sort_buffer_size = 2M

# read_rnd_buffer_size = 2M

#启动

[root@www mysql55]# ./bin/mysqld_multi --defaults-file=./my.cnf start 3306        #3307、3308同样

[root@www mysql55]# ./bin/mysqld_multi --defaults-file=./my.cnf statr 3306-3308   #亦可同时启动

#关闭

[root@www mysql55]# ./bin/mysqld_multi --defaults-file=./my.cnf stop 3306

ps -ef|grep 3306 #发现进程还存在

#查看/mysql55/share/mysqld_multi.log 日志

Warning: Using a password on the command line interface can be insecure.

/opt/mysql55/bin/mysqladmin: connect to server at 'localhost' failed

error: 'Access denied for user 'test'@'localhost' (using password: YES)'

#由于在my.cnf配置文件设置了test用户、密码

[mysqld_multi]

mysqld     =/opt/mysql55/bin/mysqld_safe

mysqladmin =/opt/mysql55/bin/mysqladmin

user       =test

password   =test

**************

cd /tmp/

srwxrwxrwx  1 mysql mysql 0 Apr 27 08:25 mysql3306.sock

srwxrwxrwx  1 mysql mysql 0 Apr 27 08:28 mysql3307.sock

srwxrwxrwx  1 mysql mysql 0 Apr 27 08:30 mysql3308.sock

srwxrwxrwx  1 mysql mysql 0 Apr 27 08:13 mysql.sock

-rw-------. 1 root  root  0 Apr 11 23:18 yum.log

#登陆数据库

[root@www tmp]# mysql -S ./mysql3306.sock

#

mysql> show grants for root@localhost;

+---------------------------------------------------------------------+

| Grants for root@localhost                                           |

+---------------------------------------------------------------------+

| GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION |

| GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION        |

+---------------------------------------------------------------------+

2 rows in set (0.00 sec)

#授权并赋予test密码

mysql> grant shutdown on *.* to test@localhost identified by "test"  with grant option;

Query OK, 0 rows affected (0.00 sec)

即可成功关闭3306

[root@www mysql55]# ./bin/mysqld_multi --defaults-file=./my.cnf stop 3306