Upgrade MySQL 5.6 to 5.7 on Centos 7

Reference: http://linuxresolved.com/upgrade-mysql-5-6-mysql-5-7-centos/ 1. Important backup your databases before upgrade. Create a backup of the original MySQL data otherwise you may lose all your data. $ mysqldump -v -u root -p --all-databases > /tmp/backups/mysql56_all_databases_dump.`date +%F`.sql   2. # service mysql stop $ cp /var/lib/mysql /var/lib/mysql56.original 2. Download the MySQL 5.7 RPM $ wget http://repo.mysql.com/mysql57-community-release-el7.rpm -P /tmp/ 3. … 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 5.7 on RHEL or Centos

Reference: https://dev.mysql.com/doc/refman/5.7/en/linux-installation-yum-repo.html#yum-repo-installing-mysql   <<<INSTALL STEPS>>>______________ Steps for a Fresh Installation of MySQL Check if mysql is already installed earlier. Login as root and run: root># rpm -ql mysqlpackage mysql is not installed root># rpmquery mysqlpackage mysql is not installed check linux version:/root># cat /etc/redhat-releaseCentOS Linux release 7.8  STEP 1: Adding the MySQL Yum Repository Create … Continue reading Install MySQL 5.7 on RHEL or Centos