Remote MySQL on Private Backend Network

[kar]

Hello all,

I have a central MySQL server connected exclusively to a private back-end network. So, each web server has a public interface and private interface. I have successfully configured DA, phpMyAdmin, and Roundcuble to connect to MySQL over the private network. The problem I have is: when a user creates a database in DA, it sets the permissions for the public IP address and localhost, but NOT the private IP address; so no joy authenticating any DA created MySQL user over the only link I have to the database.

Does anyone have any suggestions? I REALLY don't want to install MySQL on the web server itself.

Thanks!

 

[zEitEr]

Hello,

I'm not sure if such a behavior, you mentioned above, is hardcoded into directadmin or not, but you can set any permissions you need with custom scripts (of course you'll need some programming skills):

database_create_pre.sh
database_user_create_post.sh

Note that database_create_user_post.sh will not be called when a database and it's user is being created. This means that any code used in database_user_create_post.sh will have to be doubled in database_create_post.sh as well for anything you want done to a new user.

 

[kar]

Solved, Thank you!

Hi Alex,

I looked at just about everything except those scripts. It works perfectly.

THANK YOU!!!

Keith