remote MSQL server option in DA

[servertweak]

this is the only thing that is needed in every DA box as mysql can load up a single server.

I'm working on this now but if someone can help that wil be nice too.

Option
ON/OFF

add remote mysql server

Copy And Paste Existing Database




Todays real world single boxes is in the pass. i can deal with email apache php in one box mysql is a must on a ded set to remote

 

[servertweak]

Reply From DA

If you want to have DA on one box, and mysql standalone on another, you'd need to tweak a few things.

- /usr/local/directadmin/conf/mysql.conf: add:
host=1.2.3.4
to the file, where 1.2.3.4 is the other machines IP address.

- /var/www/html/phpMyAdmin/config.inc.php
$cfg['Servers'][$i]['host'] = 'localhost'; // MySQL hostname or IP address

change 'localhost' to the other host or IP.

- the da_admin user would need to be setup on the other machine:
http://help.directadmin.com/item.php?id=45
But use your DA server host/IP instead of 'localhost' so DA can access it.

1) Yes, assuming the above steps are done
2) Yes, DA would connect remotely.
3) see above. Users might also have to add access hosts for your machine so their scripts can access the remote box.

 

[servertweak]

the problem

The information posted above only changes the remote mysql for the one user. Each user is going to need the new remote mysql privaledge added as well as recoding the websites. DA may have a tool for mysql but I am not familiar with it and do not know if it exists.

 

[DirectAdmin Support]

MySQL Access Hosts?

User Level -> MySQL Databases -> user_dbname -> Add Access Host

The host you add can be either the server IP of the DA machine, or just the % character to allow any IP (less secure, but fewer issues).

Once you add an access host for a database, it will apply to all users, and any new users created for that database.

John

 

[servertweak]

hello
i'd like to work fully remotely, just like it would on localhost where new and existing clients can add edit and phpmyadmin.