Remote MYSQL server and Directadmin

FastAttack

Verified User
Joined
Dec 27, 2004
Messages
51
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
 
Last edited:
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?
 
Never tried it.

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

Anyone else?

Jeff
 
Back
Top