REDHAT5 installing MySQL 5.6

Find the download link on the website

Http://dev.mysql.com/get/Downloads/MySQL-5.6/MySQL-5.6.19-1.rhel5.x86_64.rpm-bundle.tar

Wget down

wget Http://dev.mysql.com/get/Downloads/MySQL-5.6/MySQL-5.6.19-1.rhel5.x86_64.rpm-bundle.tar

Extract

TAR-XVF Mysql-5.6.19-1.rhel5.x86_64.rpm-bundle.tar

After that, there are a lot of files, mainly installing server and client

RPM-IVH mysql-server-5.6.19-1.rhel5.x86_64. rpm and Rpm-ivh mysql-client-5.6.19-1.rhel5.x86_64.rpm

Start MySQL

Start

If the error is complete, please remove the MySQL before installing, including the process

1024

Locate the. mysql_secret file under the user directory

VI ~/.mysql_secret

Find the generated random password login

Mysql-u root-pxxxxx

Need to change password for first time login

SET PASSWORD = PASSWORD ('123456')

To change the way root is accessed

 use MySQL

Perform an update operation

Set host = '% ' where user = ' root ';   for key ' PRIMARY '

It's wrong.

mysql> flush Privileges;

Complete, you can connect remotely.

Reference:

http://my.oschina.net/quttap/blog/86665

http://rabbit2013.blog.51cto.com/6658739/1341055

http://blog.csdn.net/yanzi1225627/article/details/8694358