Upgrade MySQL 5.6 to 5.7 on Centos 7

Reference: http://linuxresolved.com/upgrade-mysql-5-6-mysql-5-7-centos/ 1. # service mysql stop 2. Important backup your databases before upgrade. Create a backup of the original MySQL data. $ cp /var/lib/mysql /var/lib/mysql.original 2. Download the MySQL 5.7 RPM $ wget http://repo.mysql.com/mysql57-community-release-el7.rpm -P /tmp/ 3. Remove the MySQL-Community RPM that contains MySQL 5.6 $ yum remove mysql-community-release 4. Install the MySQL 5.7 RPM … Continue reading Upgrade MySQL 5.6 to 5.7 on Centos 7

MariaDB vs MySQL

CentOS — MariaDB 5.5 replaced MySQL in CentOS 7 Debian — Jessie includes MariaDB 10.0, Stretch includes MariaDB 10.1 as default. Fedora — MariaDB 5.5 became the default relational database in Fedora 19. Fedora 26 includes MariaDB 10.1.[1] Red Hat Enterprise Linux — MariaDB 5.5 has been the default "MySQL" database since RHEL 7 SUSE Linux Enterprise — MariaDB 10.0 is the default relational database option on 12-SP2. Ubuntu —MariaDB 5.5 was included in Trusty … Continue reading MariaDB vs MySQL

Install MySQL on RHEL or Centos

<<<NEXT STEPS>>>______________ check if mysql is already installed earlier. Login as root and run: root># rpm -ql mysql package mysql is not installed root># rpmquery mysql package mysql is not installed check linux version: /root># cat /etc/redhat-release Red Hat Enterprise Linux Server release 6.9 (Santiago) root># sudo yum install mysql-server Installed: mysql-server.x86_64 0:5.1.73-8.el6_8 Dependency Installed: mysql.x86_64 0:5.1.73-8.el6_8                          … Continue reading Install MySQL on RHEL or Centos