even though I can log into mysql through ssh and it appears to be functioning.
When I check the configuration I get the following response:
MySQL does not appear to be installed and running on your system, or has not yet been set up properly in Webmin's MySQL Database module. If your system does not use MySQL, it should be disabled in Virtualmin's module configuration page.
.. your system is not ready for use by Virtualmin.
I've attempted to configure Webmin's module, from fixing some file locations in the module config to entering my root password. I know it's my root password: I can log into what appears to be a completely functional mysql server via ssh. I even changed my password and double checked. No luck.
What I get when I enter this 100% grade A mysql root password is:
Login failed : Incorrect administration username or password.
When I look at the mysql logs in /var/log, I find they are empty.
So I went about trying to see if there was anything about mysql that needed fixing. The installation seemed a bit, umm, funky, so I figured I'd reinstall.
apt-get --reinstall said it could not log in. I initially found I -- really-- could not stop mysqld using /etc/init.d/mysql stop. I used mysql_zap to kill it off, and I know it's gone.
However no amount of apt-get or dpkg will reinstall the packages (which I suspect were only partially installed, and that the files laying around are from two different versions of mysql). They return an error stating that mysql is still running and they can't stop it (it's not... it's really not... it is running only in the twisted mind of the debian package system).
I am beginning to get that up-a-creek-without-a-paddle sensation (i.e. that the virtualmin install over the d*** system I found on this server has become an ugly mess and that I'm not going to be able to dig out of it by my deadline).
If anyone has a clue where to proceed from here, I'm in desperate need for clues (and a functioning mysql server that can serve up a prominent blog starting in a couple of days)