How to use Yum to upgrade and install MySQL 5.5 on CentOS / RHEL 6.7?

Linux Enterprise (RHEL) 6 X and CentOS 6 X were released with MySQL 5.1 because it was a stable version at that time After that, sun / Oracle released MySQL 5.5 The following provides specific update and installation methods The mysql55 installation package has been renamed mysql55w (mysql51 to mysql51w) This ensures that it does not conflict with the SCL package First, set up the yum database and install rpm on your CentOS / RHEL rpm -Uvh https://dl.fedoraproject.org/pub/epel/epel-release-latest-6.noarch.rpm RPM - uvh https://mirror.webmatic.com/yum/el6/latest.rpm if you have installed a MySQL client or server (RPM - Q MySQL MySQL server), you can upgrade it with the following command: Yum install mysql ` uname - I ` Yum plugin replace Yum replace MySQL - replace with mysql55w "Yum install MySQL" here can ensure that Yum plugin replace solves the dependency problem when MySQL server is installed Otherwise, you can run the following command to install MySQL client and server: Yum install mysql55w mysql55w server Before using the server for production, you should upgrade the existing tables You can do this by turning on the server and running the MySQL upgrade script Depending on the size of the database, it may take some time Service mysqld start the following command is used for the username with password If there is no root password, remove "- P" mysql_upgrade -u root -p