Remote Database Help

[Gordon55M]

Read this thread viewtopic.php?f=10&t=4054 and am still having issues.

I am trying to get a remote MySQL DB working with Vesta CP. Here is where I am at:

I am using Digital Ocean and have identical Ubuntu 12.04.4 X64 servers. One is running Vesta, the other MySQL. Both are on a private network. I set up a remote user on the MySQL called VestaUser and allowed remote access using the private IP address from the Vesta CP server. I ran the following code on the Vesta CP server:

Code: Select all

v-add-database-host mysql new-server.com root password

Code: Select all

v-list-database-hosts

Code: Select all

v-suspend-database-host mysql localhost

Everything looks good and I am able to choose my private IP address to create DB's in the Vesta CP without error messages. However a few issues arise.
-Both localhost and my private IP address are options in the drop down still even after I suspended localhost.
-When I create a DB using the private IP drop-down and click "Open phpMyAdmin", it doesn't open as it points to the private IP not a public one...how do I set it to go to the public when using a private IP (If possible?)?
-When I visit the public IP phpMyAdmin of the remote MySQL server, none of the databases that I created in VestaCP exist. Does that make sense?

[Gordon55M]

Since I haven't received a response, does anyone know if there is a tutorial written on this topic that I can reference?

[imperio]

Hi,

Both localhost and my private IP address are options in the drop down still even after I suspended localhost

This problem is confirmed

[MAN5]

Hi,

Both localhost and my private IP address are options in the drop down still even after I suspended localhost

This problem is confirmed

Hi. Too need this option.
I would like to remove "LOCAL HOST" from drop down menu.
Any help?

[MAN5]

Hi,

Both localhost and my private IP address are options in the drop down still even after I suspended localhost

This problem is confirmed

Hi. Too need this option.
I would like to remove "LOCAL HOST" from drop down menu.
Any help?

Ok Got-it..
Simply edit the file:
/usr/local/vesta/conf/mysql.conf
Than 'Restart MySQL service'.

- The dropdown sequence & the hosts are following from this file.
- The Database maximum DBs counting also from here.

[liewcf]

Ok Got-it..
Simply edit the file:
/usr/local/vesta/conf/mysql.conf
Than 'Restart MySQL service'.

- The dropdown sequence & the hosts are following from this file.
- The Database maximum DBs counting also from here.

Thanks! I was looking for this solution!

[skurudo]

Ok, closed.