CentOS 6.4 Under compile install MySQL 5.6.14

Overview:

In CentOS 6.4, the installation of MySQL via Yum is version 5.1, older, so you want to install the high version of 5.6.14 via source code.

Body:

One: Uninstall the old version

Use the following command to check if MySQL Server is installed

Rpm-qa | grep MySQL

Some words are unloaded by the following command

RPM-E MySQL//normal Delete mode

RPM-E--nodeps MySQL//brute force Delete mode, if you use the above command to delete, prompted to have other dependent files, then use this command can be strongly deleted

Two: Install MySQL

Install packages required for compiling code

Yum-y install make gcc-c++ cmake bison-devel ncurses-devel

Download MySQL 5.6.14

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

Tar xvf mysql-5.6.14.tar.gz

CD mysql-5.6.14

Compiling the installation

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

Make && make install

The compiled parameters can be referenced http://dev.mysql.com/doc/refman/5.5/en/source-configuration-options.html

Three: Configure MySQL

Set permissions

Use the following command to see if there are MySQL users and user groups

CAT/ETC/PASSWD View the list of users

Cat/etc/group viewing a list of user groups

If not, create

Groupadd MySQL

useradd-g MySQL MySQL

Modify/usr/local/mysql Permissions

Chown-r Mysql:mysql/usr/local/mysql

Modify/usr/local/mysql Permissions

Go to installation path

Cd/usr/local/mysql

Enter the installation path, execute the initialization configuration script, create the system's own database and table

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

Note: When starting the MySQL service, will be in a certain order to search my.cnf, first in the/etc directory, find will search "$basedir/my.cnf", in this case is/usr/local/mysql/ MY.CNF, this is the default location for the new MySQL configuration file! Note: After the minimum installation of the CentOS version 6.4 operating system, there will be a my.cnf in the/etc directory, which will need to be renamed to a different name, such as:/etc/ My.cnf.bak, otherwise, the file will interfere with the correct configuration of the source installed MySQL, resulting in the inability to start.

Start MySQL

Add services, Copy service scripts to the INIT.D directory, and set boot boot

CP Support-files/mysql.server/etc/init.d/mysql

Chkconfig MySQL on

Service MySQL Start--start MySQL

Configure users

After MySQL starts successfully, Root does not have a password, we need to set the root password.

Before setting, we need to set path, or we can't call MySQL directly

Modify the/etc/profile file to add at the end of the file

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

Export PATH

Close the file, run the following command, and let the configuration take effect immediately

Source/etc/profile

Now, we can enter MySQL in the terminal directly into the MySQL environment

Execute the following command to modify the root password

Mysql-uroot

mysql> SET PASSWORD = PASSWORD (' 123456 ');

To set the root user to have remote access, perform

Mysql> g RANT all privileges on * * to ' root ' @ ' 172.16.% ' identified by ' password ' with G RANT OPTION;

Where password is remote access, the root user's password can be different from the local one.

Configuring firewalls

Firewall 3306 port is not enabled by default, to remote access, you need to open this port

Open/etc/sysconfig/iptables

Under "-A input–m State--state new–m tcp–p–dport 22–j ACCEPT", add:

-A INPUT m state--state NEW m TCP p dport 3306 J ACCEPT

Then save and close the file, run the following command in the terminal and refresh the firewall configuration:

Service Iptables Restart

CentOS 6.4 Under compile install MySQL 5.6.14