CentOS 6.3 under MySQL 5.6 source installation

Linux operating systems: CentOS 6.3

1: Download: current MySQL version to 5.6.10

: Http://dev.mysql.com/downloads/mysql/5.6.html#downloads

Select "Source Code"

It is best to register an Oracle account before this

2: Necessary Packages

Yum-y install gcc gcc-c++ gcc-g77 autoconf automake zlib* fiex* libxml* ncurses-devel libmcrypt* libtool-ltdl-devel* Mak E CMake

3: Compiling the installation

[[email protected] ~]# Groupadd MySQL

[[email protected] ~]# useradd-r-g MySQL MySQL

[Email protected] ~]# TAR-ZXVF mysql-5.6.10.tar.gz

[Email protected] ~]# CD mysql-5.6.10

[Email protected] mysql-5.6.10]# CMake.

[[email protected] mysql-5.6.10]# make && make install

-------------------------is installed on/usr/local/mysql by default

[Email protected] ~]# chown-r mysql.mysql/usr/local/mysql

[Email protected] ~]# cd/usr/local/mysql/scripts

[Email protected] ~]#/mysql_install_db--user=mysql--basedir=/usr/local/mysql--datadir=/usr/local/mysql/data

[Email protected] ~]# Cd/usr/local/mysql/support-files

[email protected] support-files]# CP Mysql.server/etc/rc.d/init.d/mysql

[email protected] support-files]# CP my-default.cnf/etc/my.cnf

[[email protected] ~]# Chkconfig-add MySQL

[[email protected] ~]# chkconfig MySQL on

[[Email protected] ~]# service MySQL start

Starting MySQL success!

If you entered the MySQL prompt command not found

Ln-fs/usr/local/mysql/bin/mysql MySQL

[[email protected] support-files]# MySQL

Welcome to the MySQL Monitor. Commands End With; or \g.

Your MySQL Connection ID is 1

Server version:5.6.10 Source Distribution



Copyright (c) and/or, Oracle, its affiliates. All rights reserved.



Oracle is a registered trademark of the Oracle Corporation and/or its

Affiliates. Other names trademarks of their respective

Owners.



Type ' help ', ' or ' \h ' for help. Type ' \c ' to clear the current input statement.



Mysql>

mysql> status;

--------------

MySQL Ver 14.14 distrib 5.6.10, for Linux (i686) using Editline Wrapper



Connection id:1

Current database:

Current User: [email protected]

Ssl:not in use

Current Pager:stdout

Using outfile: '

Using delimiter:;

Server version:5.6.10 Source Distribution

Protocol version:10

Connection:localhost via UNIX socket

Server Characterset:utf8

Db Characterset:utf8

Client Characterset:utf8

Conn. Characterset:utf8

UNIX Sockets:/tmp/mysql.sock

Uptime:5 min sec



Threads:1 questions:5 Slow queries:0 opens:70 Flush tables:1 Open tables:63 queries per second avg:0.014

--------------

Mysql>

Installation is complete.

CentOS 6.3 under MySQL 5.6 source installation