I installed turnkey a few days ago. Nice touch to have webmin, apache, php all installed. It basically all works.
There is just one problem that I can't get solved by myself: mysql should be accessible from outside the virtual machine into which I installed turnkey linux.
What I want to do ist:
# mysql 192.168.0.80 -u root -p
ERROR 1045 (28000): Access denied for user 'root'@'localhost'
.. it doesn't matter if I set a password or not, whether I disable the firewall or not (I get a password request, so there is a conection, I am just not allowed in)
What I tried so far:
PHPMyAdmin tells me that there is a user root with host % (all) with all privileges (I tried with and without a password)
I tried setting the bind-address in my.cnf
I disabled the firewall in webmin
I reinstalled the whole turnkey-lamp-11.0-lucid-x86 from iso (the first time I used the vmware 2009.10-2 image)
... all to no avail - there is no remote access to mysql ...
could someone please tell me what I could try now? Or what configuration file I should add to provide more information?