phpmyadmin blocking remote access

[yvespires]

Hello

I did default installation of ISPconfig, can login normally on phpmyadmin page using root... but i cannot using custom user.. gettting this error:

#1045 Cannot log in to the MySQL server


Remote Acess is checked.


Any ideas?

[bruno_floyd]

Did you add the IPs of the servers/places where the user would log in from?

[yvespires]

Originally Posted by bruno_floyd

Did you add the IPs of the servers/places where the user would log in from?

nop, i left it blank so any IP can log in

tried now via terminal:

root@web2:~# mysql -u c18teste -p
Enter password:
ERROR 1045 (28000): Access denied for user 'c18teste'@'localhost' (using password: YES)

[bruno_floyd]

Try with the IP, see if it works

[yvespires]

Figured...

I did multiserver installation...following ISPConfig manual.

web.domain.com - 192.168.0.1 / xxx.xxx.64.50
ns1.domain.com - 192.168.0.2 / xxx.xxx.64.51
ns2.domain.com - 192.168.0.3 / xxx.xxx.64.52
db.domain.com - 192.168.0.4 / only internal access

http://web.domain.com/phpmyadmin using root login works, but only lists db from web.domain.com... seems right

But when i create website database and try to login using normal user http://web.domain.com/phpmyadmin, for some reason phpmyadmin at web.domain.com cant connect to db.domain.com

is something wrong in my setup?!

[yvespires]

solved!

added db.domain.com at phpmyadmin login screen