Peter Meyer's picture

remote mysql access

Hi,

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

Enter password:

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:

http://www.turnkeylinux.org/docs/database-remote-access

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?

Thanks

Forum: