CentOS 6.4 64-bit installation MySQL 5.6.24

Download the installation package

Due to the website access and version selection download is not very convenient, using Suho source for download

http://mirrors.sohu.com/mysql/MySQL-5.6/

Download the following three installation packages:

mysql-server-5.6.24-1.el6.x86_64.rpm

mysql-client-5.6.24-1.el6.x86_64.rpm

mysql-devel-5.6.24-1.el6.x86_64.rpm

To install

If you have MySQL, please uninstall before installing

[Email protected] files]# Rpm-qa | grep MySQL

Yum remove-y mysql-libs-5.1. 2. el6_3.x86_64

[Email protected] files]#RMmysql-server-5.6. --1. el6.x86_64.rpm. [Email protected] files]# rpm-IVH mysql-client-5.6. --1. el6.x86_64.rpmPreparing. ########################################### [ -%]   1: Mysql-client ########################################### [ -%][[email protected] files]# rpm-IVH mysql-devel-5.6. --1. el6.x86_64.rpmPreparing. ########################################### [ -%]   1: Mysql-devel ########################################### [ -%]

Start the MySQL start start stop stop restart restart

[[Email protected] files]# service MySQL startstarting MySQL. SUCCESS!

Check if boot is on, set to boot

grep MySQL

[[email protected] files]# chkconfig MySQL on

Open Remote permissions root for user 123456 for password, firewall needs to open 3306 port

enter MySQL >grant USAGE on * * to ' nbdx ' @ '% ' identified by ' 123456 ' with GRANT OPTION; >flush privileges;

Enter error handling:

Mysqld_safe--skip-grant-tables &
Mysql-uroot-p
>use MySQL;
>update Mysql.user Set Password=password (' 123456 ') where user= ' root ';
>flush privileges;

Error:

1820 (HY000): Must SET PASSWORD before executing this statement

>set PASSWORD = PASSWORD ('123456');

　　

CentOS 6.4 64-bit installation MySQL 5.6.24