L C Wyche, nafis,
To offer a sensible explanation and exact steps to fix the environment, we need to know how you got there.
At some points, you had at least
- MySQL 5.5 installed from Ubuntu repo;
- MariaDB 5.5 installed from Ubuntu repo;
- MySQL 5.6 installed from the customized MySQL repo;
- MariaDB 10.1 installed from the official MariaDB repo;
possibly something else.
It also doesn't help that both of you have some i386 packages installed alongside with amd64. I've seen before mysql-common:i386 coming from MySQL repo along with MySQL 5.6 server (amd64), don't know the conditions why it happens. Possibly libmysqlclient18:i386 came from the same source.
I know for a fact that switching between versions and distributions like that causes various problems on deb-based systems, but to know which flavor of the problem you hit, it's necessary to understand in which order you were installing the versions and, very importantly, how you were doing it (exact apt-get commands: whether it was install, or upgrade, or dist-upgrade, and if it was install, which packages you listed explicitly).
Without knowing more, I can only make some general suggestions.
1) As already mentioned (none of you said whether it helped or not), try to manually remove all packages starting from mysql-, mariadb-, libmysql* and libmariadb* (and even purge if possible). Maybe it will help to fix the broken environment. After you removed everything, you can also retry install -f.
2) After it is fixed,
- if you want to have MariaDB 5.5, remove from source lists both MySQL 5.6 repo and MariaDB repo, and install mariadb-server from the Ubuntu repo.
- if you want to have MySQL 5.5, remove from source lists both MySQL 5.6 repo and MariaDB repo, and install mysql-community-server from the Ubuntu repo.
- if you want to have MariaDB 10.0 or 10.1, remove from source lists MySQL 5.6 repo, add MariaDB 10.0 or 10.1 repo and install mariadb-server.
- if you want to have MySQL 5.6, remove from source lists MariaDB repo and install mysql-server.
Whichever you choose, you should never have both MySQL 5.6 repo and MariaDB repo enabled at the same time. It really makes no sense because there is nothing else useful in the repos apart from the servers/clients, and you cannot have both servers installed simultaneously.
Please paste the exact command that you ran and the output.
Also, please paste output of dpkg -l | grep -E 'maria|mysql'