How to upgrade mysql 5.7 to 8.0 in Ubuntu 16.04
We will complete this task in two phases. upgrade mysql 5.7 to 8.0 in Ubuntu 16.04
PHASE 1 - Uninstalling mysql 5.7
PHASE 2 - Installing mysql 8.0
--------------------------------------------------------------------------------------------------------------
Firstly, backup your databases from phpmyadmin if you have phpmyadmin installed on your server. OR, take backup of the databases using mysqldump.
Import and Export Databases in MySQL using mysqldump
--------------------------------------------------------------------------------------------------------------
Let's begin with phase 1 - uninstalling mysql 5.7
Step 1. Log into your linux server via ssh and stop mysql services
systemctl stop mysql
Step 2. Now run the following command to uninstall MySQL package
upgrade mysql 5.7 to 8.0 in Ubuntu 16.04
sudo apt-get remove dbconfig-mysql
Step 3. Now remove the all files related to MySQL
sudo apt-get remove --purge mysql*
Step 4. It asks to remove data directories, if you want to remove , Enter on Yes button.
Step 5. Next it asks to remove all MySQL databases, if you want to remove, Enter on Yes button.
Step 6. To remove undependent packages run the following command
sudo apt-get autoremove
Step 7. To clean local apt pacakges run the following command
sudo apt-get autoclean
We have now installed mysql 5.7 from ubuntu 16.04.
--------------------------------------------------------------------------------------------------------------
Now let's start with phase 2 - installing mysql 8.0
Step 1. Install the MySQL/Oracle Apt repository first
wget https://dev.mysql.com/get/mysql-apt-config_0.8.14-1_all.deb
dpkg -i mysql-apt-config_0.8.10-1_all.deb
The MySQL APT repository installation package allows you to pick what MySQL version you want to install, as well as if you want access to Preview Versions.
Step 2. Update repository configuration and install MySQL Server
apt-get update
apt-get install mysql-server
The installation process asks you to set a password for the root user:
Step 3. Next, the installation script asks you whether to use Strong Password Encryption or Legacy Authentication:
While using strong password, it is recommend for security purposes, not all applications and drivers support this new authentication method. Going with Legacy Authentication is a safer choice
All Done upgrade mysql 5.7 to 8.0 in Ubuntu 16.04
Step 4. You should have MySQL 8.0 Server running. You can test it by connecting to it with a command line client:
MySQL upgraded on Ubuntu 16.04 LTS
Thank You!