Remote SQL with VestaCP Topic is solved

Questions regarding the Database Server
MySQL, PostgreSQL, MariaDB, Percona Server, phpMyAdmin, phpPgAdmin
Vegas10128
Posts: 4
Joined: Tue Aug 16, 2016 4:58 pm

Remote SQL with VestaCP

Postby Vegas10128 » Mon Apr 10, 2017 7:49 pm

Hello All,
My question of the day with VestaCP SQL Server.

Is it possible to access SQL Remotely from the VestaCP Server?
If so? how can i go about setting it up locally?

peterbrinck
Posts: 15
Joined: Wed Jun 24, 2015 8:13 am

Re: Remote SQL with VestaCP  Topic is solved

Postby peterbrinck » Tue Apr 11, 2017 12:53 pm

Do you want to access a database created by Vesta or do you want to add another MySQL server to Vesta?

Both are possible, the database created by Vesta isn't only local connections. You should be able to connect using your servers IP.

And if you want to add a remote MySQL server, just follow the Vesta docs:
https://vestacp.com/docs/#how-to-add-re ... ase-server

Vegas10128
Posts: 4
Joined: Tue Aug 16, 2016 4:58 pm

Re: Remote SQL with VestaCP

Postby Vegas10128 » Tue Apr 18, 2017 4:43 pm

Peterbrinck,

Thank you for the reply!
I am looking towards having 2 Vesta CP Web-servers, and one Vesta CP to manage MySQL Databases,

The Vesta CP i am wanting to store all of the MySQL Files i would like to be able to open firewall ports and allow the web-servers to connect to this server

What firewall ports does VestaCP use for SQL?

mehargags
Moderators
Posts: 785
Joined: Sat Sep 06, 2014 9:58 pm
Contact:

Re: Remote SQL with VestaCP

Postby mehargags » Wed Apr 19, 2017 7:21 am

The Default mysql port is 3306


Return to “Database Server”



Who is online

Users browsing this forum: No registered users and 4 guests