Remote MYSQL server and Directadmin

[FastAttack]

After reading countless posts about Directadmin and a dedicated mysql server, I was able to get directadmin and its scripts to work with a dedicated mysql machine ( thanks DA for adding the hosts option)

THE only problem I have is, when it creates a DB and user
under the allowed hosts , it will put the following allowed hosts:

localhost
publicIP of the webserver

what I need is

localhost
PrivateIP of the webserver ( secondary nic card)


.

PHPmyadmin
and the config file under directadmin for mysql is setup with the private IP not the public IP.. ( Phpmyadmin will not connect to mysql as the private ip is not an allowed host, if I put the public IP it will work)


I saw someone said that they ended up making a custom .sh file to add the IP to the allowed hosts when creating a User and DB.


Am I missing something? or do I hav to do some sort of templated edit?

thanks guys

 

[FastAttack]

hmm anyone?

 

[intelliot]

I'd like to know about this too.

Once DirectAdmin is setup to work with MySQL on a separate, dedicated MySQL server, can I remove MySQL from the web server to decrease the overhead?

 

[nobaloney]

Never tried it.

Don't know why not, as long as no-one/nothing is referring to it.

Anyone else?

Jeff