I have the need to install mysql 5.6 on a 16.04 machine because the provided 5.7 is not compatible with the application I'm deploying.
I followed this approach that seemed to be working, until I had to set some variables in the my.cnf file. I noticed the whole [mysqld] section was missing, and creating one was of no help.
So, further investigating,
dpkg -l | grep mysql
showed that I had most mysql packages version 5.6 except mysql-common, which came from the main xenial repo so it was 5.7, and installing mysql-common-5.6 would raise a conflict between the two and would not allow me to install it.
Since the description of the package is
MySQL database common files, e.g. /etc/mysql/my.cnf
I can imagine it's the reason why I'm having issues with my.cnf and related files. Any idea how I could force mysql-common-5.6 to be installed instead of mysql-common?
Thanks in advance