Downgrade Mysql 5.7 to 5.6 in Ubuntu from terminal

first ssh to the remote system via command:
remove 5.7
sudo apt-get remove --purge mysql-server mysql-client mysql-common
sudo apt-get remove --purge mysql*
sudo apt-get remove --purge mysql-apt-config
sudo apt-get autoremove

After these steps I installed again everything solved the problem. ( not necessary though )

sudo apt-get install mysql-server libapache2-mod-auth-mysql php5-mysql

Installing mysql 5.6
apt-get install mysql-server-5.6
Configuring users in mysql
mysql -u root -p
CREATE USER ‘fitset’@’localhost’ IDENTIFIED BY ‘volleyball2013’;
CREATE USER 'myuser'@'%' IDENTIFIED BY 'mypass';


GRANT ALL ON *.* TO 'myuser'@'localhost';
GRANT ALL ON *.* TO 'myuser'@'%';

and finally,


Copyright © 2020. Powered by WordPress & Romangie Theme.