Linux under mysql5.6 RPM package installation

1.Preparing the installation package

download the corresponding Linux version of the RPM installation package address (http://downloads.mysql.com/archives/community/)

This example uses a CentOS6.5 Linux . Download the corresponding installation package as follows:

650) this.width=650; "src=" Http://s5.51cto.com/wyfs02/M00/7E/5D/wKiom1b9F8njDSJNAAG4uyHsi2Y956.png "title=" Qq20160327192444.png "alt=" Wkiom1b9f8njdsjnaag4uyhsi2y956.png "/>

Description: Mysql-server is the basic service software,mysql-client is the client command software, we need to login MySQL with the client command to modify the default password, and so on, so these two must be downloaded and installed.

2.Start Installation

after the download is complete, upload it to Linux via the tool . Download the two installation package named

mysql-server-5.6.15-1.el6.i686.rpm

mysql-client-5.6.15-1.el6.i686.rpm

Note: Linux basic commands do not make too much explanation

See If there is a MySQL dependency package on Linux

Rpm–qa Mysql-libs

650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M02/7E/5D/wKiom1b9GOqx5I-hAAAMNDlapXg418.png "title=" QQ picture 20160327194628.png "alt=" Wkiom1b9goqx5i-haaamndlapxg418.png "/>

The MySQL dependency package is installed by default and needs to be uninstalled. Otherwise there will be a conflict with the installation

Uninstalling Mysql-libs

method 1: Uninstall using the Yum command

The Yum command is very smart enough to offload a dependency package, but only if Linux is configured with a Yum source and has access to the network, it is not enough to unload

Yum–y Remove Mysql-libs

650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M02/7E/5D/wKiom1b9GXXx8kGhAAAHrijTmCM056.png "title=" QQ picture 20160327201940.png "alt=" Wkiom1b9gxxx8kghaaahrijtmcm056.png "/>

method 2: Uninstall using the rpm command

Rpm–e Mysql-libs

650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M02/7E/5D/wKiom1b9GfmjxdLbAAAjpVkHGpQ789.png "title=" QQ picture 20160327195636.png "alt=" Wkiom1b9gfmjxdlbaaajpvkhgpq789.png "/>

The error message appears to be postfix dependent. The dependent packages need to be unloaded to continue the uninstallation. Uninstalling Postfix

rpm–e postfix

650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M01/7E/59/wKioL1b9Gvrxk2chAAAUbReuKTg680.png "title=" QQ picture 20160327200052.png "alt=" Wkiol1b9gvrxk2chaaaubreuktg680.png "/>

Postfix is also Cronie dependent on another package and continues to unload Cronie

Rpm–e Cronie

650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M01/7E/59/wKioL1b9G46SDuL4AAAcJ3eo7Rg531.png "title=" QQ picture 1115277627822.png "alt=" Wkiol1b9g46sdul4aaacj3eo7rg531.png "/>

found that Cronie was also dependent on the other two packages, continue to uninstall Cronie-anacron,crontabs

Uninstalling Cronie-anacron

Rpm–e Cronie-anacron

650) this.width=650; "src=" Http://s4.51cto.com/wyfs02/M00/7E/5D/wKiom1b9GxuAVbtdAAAUeY5Z0fc707.png "title=" QQ picture 20160327200520-copy. png "alt=" Wkiom1b9gxuavbtdaaauey5z0fc707.png "/>

at this time found Cronie-anacron and rely on Cronie, first uninstall Crontabs

Rpm–e Crontabs

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/7E/5D/wKiom1b9G0bjDLJ5AAAV9lQ5jQw212.png "title=" QQ picture 20160327200856-copy. png "alt=" Wkiom1b9g0bjdlj5aaav9lq5jqw212.png "/>

Crontabs was also Cronie-anacron dependent, and finally found that the three packages are ring-dependent. Their dependence on Mysql-libs is:mysql-libs relies on Postfix,postfix relies on Cronie, Cronie relies on Crontabs,crontabs relies on cronie-anacron,Cronie-anacron and relies on Cronie. The workaround is to unload Cronie crontabs and Cronie-anacron at the same time

Rpm–e Cronie Cronie-anacron Crontabs

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/7E/5D/wKiom1b9G7CghrukAAAIim05sA8322.png "title=" QQ picture 124124214141.png "alt=" Wkiom1b9g7cghrukaaaiim05sa8322.png "/>

then uninstall postfix and mysql-libs

rpm–e postfix

Rpm–e Mysql-libs

650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M01/7E/5D/wKiom1b9G_2BISYTAAAPc2-AVEE915.png "title=" QQ picture 20160327201612.png "alt=" Wkiom1b9g_2bisytaaapc2-avee915.png "/>

This method can also be used to unload if a dependency on another package is encountered

start installation After uninstallation is complete Mysql-server and mysql-client installation package I put it under the/usr/local.

And then the chicken scene happened.

RPM–IVH mysql-server-5.6.15-l.el6.i686.rpm

650) this.width=650; "src=" Http://s5.51cto.com/wyfs02/M01/7E/5D/wKiom1b9HGmxZmsvAAAnevOHoYs651.png "title=" QQ picture 20160327202720.png "alt=" Wkiom1b9hgmxzmsvaaanevohoys651.png "/>

installation Mysql-server also needs to install Perl ( available from /usr/bin/perl) and Libaio files,perl and Libaio for the installation package can be searched and downloaded to http://rpmfind.net.

because Perl depending on the installation package too much, use the Yum mode installation Execution yum–y Install Perl to see if the installation was successful.

Rpm–q Perl

650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M02/7E/5D/wKiom1b9HLDwuYHqAAAMcy5h0m8114.png "title=" QQ picture 20160327205858.png "alt=" Wkiom1b9hldwuyhqaaamcy5h0m8114.png "/>

A description of the installation package name appears that has been installed.

Install libaio.so, login http://rpmfind.net

650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M02/7E/59/wKioL1b9HXni4zxyAABoRZfZ6DY238.png "title=" QQ picture 20160327210227.png "alt=" Wkiol1b9hxni4zxyaaborzfz6dy238.png "/> click Search , Drop-down Select the corresponding version of the installation package

650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M00/7E/59/wKioL1b9HZiyVkyGAADBmqNVlAk552.png "title=" QQ picture 20160327210327.png "alt=" Wkiol1b9hziyvkygaadbmqnvlak552.png "/>

upload to Linux after download is complete , install Libaio

RPM–IVH libaio-0.3.110-5.fc23.i686.rpm

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/7E/5E/wKiom1b9IUSgQWlDAAAhnhhQpNc484.png "title=" QQ picture 20160327210605.png "alt=" Wkiom1b9iusgqwldaaahnhhqpnc484.png "/>

Continue installation Mysql-server

RPM–IVH mysql-server-5.6.15-l.el6.i686.rpm

650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M00/7E/5E/wKiom1b9IbLyce_nAAAXtDJJeOk902.png "title=" QQ picture 20160327210753.png "alt=" Wkiom1b9iblyce_naaaxtdjjeok902.png "/>

continue installation After installation is complete Mysql-client

RPM–IVH mysql-client-5.6.15-l.el6.i686.rpm

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/7E/5E/wKiom1b9Ic7CohZKAAAYxScjwu8080.png "title=" QQ picture 20160327210903.png "alt=" Wkiom1b9ic7cohzkaaayxscjwu8080.png "/>

View Mysql-server,mysql-client is installed successfully

Rpm–q Mysql-server mysql-client

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/7E/5A/wKioL1b9IqPQTOE_AAASE-NlaqQ947.png "title=" QQ picture 20160327211012.png "alt=" Wkiol1b9iqpqtoe_aaase-nlaqq947.png "/>

3ConfigurationMysql

Modify the configuration file location

Cp/usr/share/mysql/my-default.cnf/etc/my.cnf

650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M02/7E/5E/wKiom1b9IjTRlBX9AAAKj0imvGQ614.png "title=" QQ picture 20160327211217.png "alt=" Wkiom1b9ijtrlbx9aaakj0imvgq614.png "/>

Initializing the database

/user/bin/mysql_install_db

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/7E/5A/wKioL1b9IxrD77KBAAAGNHCPRNw853.png "title=" QQ picture 20160327211425.png "alt=" Wkiol1b9ixrd77kbaaagnhcprnw853.png "/>

Start MySQL Service

Service MySQL Start

650) this.width=650; "src=" Http://s5.51cto.com/wyfs02/M01/7E/5A/wKioL1b9IzKBg-sDAAANuYttmvI520.png "title=" QQ picture 20160327211550.png "alt=" Wkiol1b9izkbg-sdaaanuyttmvi520.png "/> view root user initial password

Cat/root/.mysql_secret

650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M00/7E/5A/wKioL1b9I0zgo2G1AAASoaHuqyA543.png "title=" QQ picture 20160327211706.png "alt=" Wkiol1b9i0zgo2g1aaasoahuqya543.png "/>

Log in to MySQL setup password as root

Mysql–uroot–pnn4yqxb8

Set password = password (' root ')

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/7E/5E/wKiom1b9IrqQvnjDAAA3DWgw3mo920.png "title=" QQ picture 20160327211910.png "alt=" Wkiom1b9irqqvnjdaaa3dwgw3mo920.png "/>

Modify the database to allow remote connections

Update user Set host = '% ' where user = ' root ' and host = ' localhost '

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/7E/5A/wKioL1b9I4XQpMuyAAAmd7-YyYc403.png "title=" QQ picture 20160327212203.png "alt=" Wkiol1b9i4xqpmuyaaamd7-yyyc403.png "/>

650) this.width=650; "src=" Http://s4.51cto.com/wyfs02/M01/7E/5A/wKioL1b9I6rjyhYvAAAf0dQGfc8468.png "title=" QQ picture 20160327212525.png "alt=" Wkiol1b9i6rjyhyvaaaf0dqgfc8468.png "/>

setting up the MySQL service boot from boot

Chkconfig MySQL on

Set MYSLQ service shutdown boot from

Chkconfig iptables off

Linux under mysql5.6 RPM package installation