MySQL 5.7 installation implications after upgrade to Bionic Beaver
I have seen deb entries to set in source.list file for which apt-get can operate.
Updating source.list in Ubuntu
Likewise, as part of my UbuntuVM upgrade I had updated source.list later through some web dashboard for Bionic Beaver and did curl or copy paste as instructed, however before in order to do certain activities I ran the following command which was fruitful.
sudo apt-get update && sudo apt-get dist-upgrade -yThen, I had installed MySQL 8 (5.8). Now I have to go back to 5.7. Now following command is basically failing,
sudo apt-get install mysql-server-5.7as we already marked our box for upgrade with dist-upgrade -y for apt-get
Now what I have to do myself, so I can install MySQL 5.7 using apt-get
MySQL 8 which is 5.8, that I had uninstalled using,
sudo apt-get remove --purge mysql-server
sudo apt-get remove --purge mysql-client
sudo apt-get remove --purge mysql-common
sudo apt-get autoremoveNow while trying to install MySQL 5.7 I am getting following error.
$ sudo apt-get install mysql-server-5.7
Reading package lists... Done
Building dependency tree
Reading state information... Done
Some packages could not be installed. This may mean that you have
requested an impossible situation or if you are using the unstable
distribution that some required packages have not yet been created
or been moved out of Incoming.
The following information may help to resolve the situation:
The following packages have unmet dependencies: mysql-server-5.7 : PreDepends: mysql-common (>= 5.5) Depends: mysql-client-5.7 (>= 5.7.22-0ubuntu0.17.10.1) but it is not going to be installed Depends: mysql-common (>= 5.6.22-1~)
E: Unable to correct problems, you have held broken packages.Nothing had gone messy so far,
$ sudo apt-get autoremove
Reading package lists... Done
Building dependency tree
Reading state information... Done
0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.Now someone let me know how I can bring back MySQL 5.7
Here is feasibility status for MySQL 5.7 installation using apt-cache policy if have xenial in sources.list
$ apt-cache policy mysql-server-5.7
mysql-server-5.7: Installed: (none) Candidate: (none) Version table: 5.7.22-0ubuntu18.04.1 -1 100 /var/lib/dpkg/statusIf I have Bionic Beaver in sources.list, I get 500
$ apt-cache policy mysql-server-5.7
mysql-server-5.7: Installed: (none) Candidate: 5.7.22-0ubuntu18.04.1 Version table: 5.7.22-0ubuntu18.04.1 500 500 bionic-security/main amd64 Packages 500 bionic-updates/main amd64 Packages 100 /var/lib/dpkg/status 5.7.21-1ubuntu1 500 500 bionic/main amd64 PackagesBasically I tried executing this once,
$ sudo dpkg -i mysql-apt-config_0.8.10-1_all.deb
