Tag Archives: downgrade mysql 5.7

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';

then,

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

and finally,

FLUSH PRIVILEGES; 
EXIT;

Copyright © 2020. Powered by WordPress & Romangie Theme.