Remote MySQL server. Access denied for user

[liteonit]

Hi,

I've been testing DirectAdmin with using a remote mysql server.

Setup specs:
Server 1, webserver:
Centos 5.2 x64
NIC 1 (external IP x.x.x.x)
NIC 2 (internal IP 192.168.4.10)

Server 2, database:
Centos 5.2 x64
NIC 1 (external IP x.x.x.x)
NIC 2 (internal IP 192.168.4.5)

The webserver is using the remote database server on IP 192.168.4.5.
I've used this tutorial for setting up a remote MySQL server.: http://help.directadmin.com/item.php?id=140
No errors while configurating the webserver and database servers

DirectAdmin on the webserver is working fine. I can create new databases, and database users without any errors.
But when I use that information while setting up something like a forum, PHP returns: "Access denied for user 'testuser_1'@'192.168.4.10' (using password: YES)".

Looks like DA doesn't configurate the new MySQL database/user.

 

[chatwizrd]

directadmin doesnt support lan ip addresses sorry

 

[nobaloney]

chatwizrd,

DirectAdmin non-support for (non-routeable) lan addresses has nothing to do with addresses supported by MySQL; MySQL address support is totally independent of DirectAdmin address support.

liteonit,

My recollection is that you have to set up external MySQL support on a per-database basis.

I'm not sure whether or not this article has all the information you need or not; give it a read.

Jeff