MySQL specified version installation

CentOS Mysql specified version installation

1. Check if MySQL RPM-related packages are installed (IMPORTANT!!!)

Rpm-qa | Grep-i MySQL

mysql-libs-5.1.61-4.el6.x86_64 Delete if it exists

Yum-y Remove Mysql-libs To delete the dependent packages.

2. Download the developed version RPM package http://downloads.mysql.com/archives/community/

Select Linux Generic version

Client Utilities and MySQL Server and mysql-devel three need to download and install

Download Mysql-server, mysql-client, and Mysql-devel using the wget copy download connection

3. After the download is complete, install the RPM package

RPM-IVH mysql-server-5.6.10-1.linux_glibc2.5.x86_64.rpm

Error message

Reason Missing Libaio Library

Workaround

wget http://mirror.centos.org/centos/6/os/x86_64/Packages/libaio-0.3.107-10.el6.x86_64.rpm

RPM-IVH libaio-0.3.107-10.el6.x86_64.rpm Installation

Reason: Missing dependency package Perl

Workaround: Yum-install-y perl

Installing Mysql-client

wget http://downloads.mysql.com/archives/get/file/MySQL-client-5.6.10-1.linux_glibc2.5.x86_64.rpm

RPM-IVH mysql-client-5.6.10-1.linux_glibc2.5.x86_64.rpm

Installing Mysql-devel

wget http://downloads.mysql.com/archives/get/file/MySQL-devel-5.6.10-1.linux_glibc2.5.x86_64.rpm

RPM-IVH mysql-devel-5.6.10-1.linux_glibc2.5.x86_64.rpm

4. Modify the configuration file after successful installation

Vi/etc/my.cnf

[Mysqld]

# Options for MYSQLD process:

#skip-grant-tables

Character_set_server=utf8

Lower_case_table_names=1

max_connections=1000

Datadir=/var/lib/mysql

After emptying, put the above copy in and save the exit.

5. Turn on MySQL service

Service MySQL Start

6. Modify the MySQL password

Service MySQL Stop

Mysqld_safe--user=mysql--skip-grant-tables--skip-networking &

Mysql-u Root

Use MySQL

UPDATE user SET Password=password ("server") WHERE user= ' root ';

The modified password is server

MySQL specified version installation