centos6.8 installing mysql5.6 "Turn"

First of all to see if this machine has default MySQL,

Local default Yes, we should first uninstall this logic in the install new.

Rpm-qa | grep MySQL

My native default installation of mysql5.1.73

Next Delete

Rpm-e--nodeps "name to uninstall"

RPM-E--nodeps mysql-libs-5.1.73-7.el6.x86_64

This machine's MySQL even if the uninstallation is complete, below we will install the new.

A friend asked, why not WGE, with RZ, in fact, with which all the same, their own habits.

Create a MySQL folder under Usr/local and then pass in the MySQL installation package

TAR-XVF Decompression

That's the files.

Then RPM-IVH mysql-server-5.6.35-1.el6.x86_64.rpm Install the service side.

Error, why press, not installed Numactl, yum install Numactl

Then come to Rpm-ivh mysql-server-5.6.35-1.el6.x86_64.rpm, this time OK.

Then install the client: RPM-IVH mysql-client-5.6.35-1.el6.x86_64.rpm

View MySQL's service status

Service MySQL Status

Start MySQL

Service MySQL Start

Stop MySQL

Service MySQL Stop

Close the service first, then enter:/usr/bin/mysqld_safe--skip-grant-tables

Use MySQL; (Çeku)

Update user Set Password = password (' 123456 ') where user = ' root '; (change password)

flush privileges; (refresh)

First Enter: SET PASSWORD = PASSWORD (' 123456 ');

Turn on remote access

Grant all privileges on * * to ' root ' @ '% ' identified by ' 123456 ';

Flush privileges;

Quit MySQL

3306 Port Release

/sbin/iptables-i input-p TCP--dport 3306-j ACCEPT

Add this setting to the rules in the firewall

/etc/rc.d/init.d/iptables Save

Setting up the MySQL service starts as the system starts

Add to System services:

Chkconfig--add MySQL

Auto Start:

Chkconfig MySQL on

Then we connect locally, if we can do it.

Turn from

centos6.8 installation mysql5.6-today's headline (www.toutiao.com)
http://www.toutiao.com/i6402439007224988161/

centos6.8 installing mysql5.6 "Turn"