CentOS system to compile and install Mysql and set up the relevant Yum source tutorial _mysql

Compiling the installation software often encounters problems, especially when the software that compiles the lamp works together, especially if the software that was previously installed affects the compilation of the program behind it, which is often the case where the previously installed software did not export the library and header files. As a result, the following software in the installation is required to specify the path of the previous installer is often prompted to find errors such as files, below, for example, MySQL

1. Installation development environment

Yum Groupinstall "Development Tools"

2. Solution Package Dependency Package

To install the package needed to compile the 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

3. Configure compilation and 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

4. Export Library Search
Create the appropriate conf file under the/etc/ld.conf.d/mysql.conf directory

Ldconfig-v | grep MySQL

5, guide the document

Ln-sv/usr/local/mysql/include/usr/include/mysql

6. Export Help Files

Vim/etc/man.config
 Manpath/usr/local/mysql/man

7. Export Binary Path

Vim/etc/profile
 path=/usr/local/mysql/bin: $PATH
source/etc/profile

PS: How to use MySQL Yum source to install update MySQL related software package
the MySQL Yum Library provides a simple and convenient way to install and update MySQL-related packages to the latest version.
MySQL Yum Library Documentation Description: http://dev.mysql.com/doc/mysql-yum-repo-quick-guide/en/
The MySQL Yum Library supports the following platforms:
Red Hat Enterprise linux 7/oracle Linux 7
Red Hat Enterprise linux 6/oracle Linux 6
Red Hat Enterprise linux 5/oracle Linux 5
Fedora, and 20
The MySQL Yum Library includes the latest packages:

• MySQL 5.6 (GA)
• MySQL 5.7 (Development release)
• MySQL 5.5 (ga-red Hat Enterprise Linux and Oracle Linux only)
• MySQL Workbench
• MySQL Fabric
• MySQL Utilities
• MySQL CONNECTOR/ODBC
• MySQL Connector/python

Rhel7/centos7/oracle linux7:

# RPM-UVH http://dev.mysql.com/get/mysql-community-release-el6-5.noarch.rpm
# RPM-UVH Http://dev.mysql.com/get /mysql-community-release-el6-5.noarch.rpm

Rhel5/centos5/oracle linux5:

# RPM-UVH http://dev.mysql.com/get/mysql-community-release-el5-5.noarch.rpm

Fedora

# FEDORA20

# RPM-UVH http://dev.mysql.com/get/mysql-community-release-fc20-5.noarch.rpm

#Fedora19

# RPM-UVH http://dev.mysql.com/get/mysql-community-release-fc19-5.noarch.rpm

# Fedora18

# RPM-UVH http://dev.mysql.com/get/mysql-community-release-fc18-5.noarch.rpm