The example of this article describes the method of installing mysql5.5.48 centos6.7. Share to everyone for your reference, specific as follows:
RPM Install MySQL 5.5.48
Download the corresponding MySQL installation package RPM files, you can go to the official MySQL website to find the corresponding version, the general need to download 3 files
Mysql-server
Mysql-client
Mysql-devel
Copy Code code as follows:
wget http://dev.mysql.com/get/Downloads/MySQL-5.5/MySQL-server-5.5.48-1.el6.x86_64.rpm
wget http://dev.mysql.com/get/Downloads/MySQL-5.5/MySQL-client-5.5.48-1.el6.x86_64.rpm
wget http://dev.mysql.com/get/Downloads/MySQL-5.5/MySQL-devel-5.5.48-1.el6.x86_64.rpm
RPM-IVH mysql-server-5.5.48-1.el6.x86_64.rpm
RPM-IVH mysql-client-5.5.48-1.el6.x86_64.rpm
RPM-IVH mysql-devel-5.5.48-1.el6.x86_64.rpm
Error installing service side:
Copy Code code as follows:
[Root@localhost ~]# RPM-IVH mysql-server-5.5.48-1.el6.x86_64.rpm
Warning:mysql-server-5.5.48-1.el6.x86_64.rpm:header V3 dsa/sha1 Signature, key ID 5072e1f5:nokey
Preparing ... ########################################### [100%]
File/usr/share/mysql/charsets/index.xml from install to mysql-server-5.5.48-1.el6.x86_64 conflicts with file from Package mysql-libs-5.1.73-5.el6_6.x86_64
File/usr/share/mysql/charsets/armscii8.xml from install to mysql-server-5.5.48-1.el6.x86_64 conflicts with file from Package mysql-libs-5.1.73-5.el6_6.x86_64
File/usr/share/mysql/charsets/ascii.xml from install to mysql-server-5.5.48-1.el6.x86_64 conflicts with file from Package mysql-libs-5.1.73-5.el6_6.x86_64
File/usr/share/mysql/charsets/cp1250.xml from install to mysql-server-5.5.48-1.el6.x86_64 conflicts with file from Package mysql-libs-5.1.73-5.el6_6.x86_64
File/usr/share/mysql/charsets/cp1256.xml from install to mysql-server-5.5.48-1.el6.x86_64 conflicts with file from Package mysql-libs-5.1.73-5.el6_6.x86_64
Cause of Error: package conflict
The centos6.7 basic Server version defaults to installing mysql5.1, so uninstall mysql5.1 first
Copy Code code as follows:
Yum-y Remove Mysql-libs-5.1*
and then reinstall it.
Copy Code code as follows:
RPM-IVH mysql-server-5.5.48-1.el6.x86_64.rpm
Start MySQL
Copy Code code as follows:
[root@localhost ~]# service MySQL start
Starting MySQL success!
CentOS Install the official RPM package MySQL after the MY.CNF solution is not found
Copy the/usr/share/mysql/my-medium.cnf file to the/etc directory,
Copy Code code as follows:
Cp/usr/share/mysql/my-medium.cnf/etc/my.cnf
the slow solution of MySQL connection in LAN
Ping is fast, MySQL connection is slow,
The reason is that MySQL has a DNS reverse resolution of the connected client.
There are 2 ways to solve this problem:
1. Write the client IP in the MySQL server/etc/hosts file, just give a name on it.
2. Add –skip-name-resolve to MY.CNF.
I hope this article will help you with your CentOS server configuration.