(Dec 29) New version 0.9.8-18 has been released

HELP - Remote MySQL database server Topic is solved

Questions regarding the Database Server
MySQL, PostgreSQL, MariaDB, Percona Server, phpMyAdmin, phpPgAdmin
Forum rules
Before creating a new topic or reply on the forum you should fill out additional fields "Os" and "Web" in your profile section.
In case of violation, the topic can be closed or response from the support will not be received.
rogerio.dobler
Posts: 10
Joined: Tue Jul 15, 2014 1:34 pm

HELP - Remote MySQL database server

Postby rogerio.dobler » Wed Aug 31, 2016 11:36 pm

I'm having trouble setting up remote MySQL database server.

I created two vps with CentOS 6.5, one to be used as a remote MySQL database server and the other as a web server. Nois two I installed vestacp:
- Apache + Nginx
- MySQL
- FTP
- iptables + fail2ban

After I configured I used these commands on the server used as webserver:

Code: Select all

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


Code: Select all

#v-list-database-hosts


so far it seems that everything works fine, but when I go on vestacp panel to create a database using the remote serividore MySQL get the following error:

Code: Select all

→ Error: Connection to mysql.mydomain.com failed


will be where did I go wrong?

Can someone help me?

skurudo
VestaCP Team
Posts: 7808
Joined: Fri Dec 26, 2014 2:23 pm
Contact:

Re: HELP - Remote MySQL database server

Postby skurudo » Thu Sep 01, 2016 6:39 am

rogerio.dobler wrote:

Code: Select all

→ Error: Connection to mysql.mydomain.com failed

will be where did I go wrong?


Resolving or Port

resolv check ->

Code: Select all

ping mysql.mydomain.com


port open check ->

Code: Select all

telnet

Code: Select all

open mysql.mydomain.com 3306

(or change port you set different)
-> DigitalOcean competition - please, support us
-> fix for phpmyadmin - nice and sweet now

rogerio.dobler
Posts: 10
Joined: Tue Jul 15, 2014 1:34 pm

Re: HELP - Remote MySQL database server

Postby rogerio.dobler » Thu Sep 01, 2016 2:12 pm

skurudo wrote:Resolving or Port

resolv check ->

Code: Select all

ping mysql.mydomain.com



Code: Select all

64 bytes from mysql.mydomain.com (000.000.000.000): icmp_seq=9 ttl=61 time=0.897 ms


skurudo wrote:port open check ->

Code: Select all

telnet



Code: Select all

# telnet mysql.mydomain.com 3306
Trying 000.000.000.000...
Connected to mysql.mydomain.com.
Escape character is '^]'.
J
5.5.51▒MFYj->1▒([tT+u0-/CCfmysql_native_passwordConnection closed by foreign host.


skurudo wrote:

Code: Select all

open mysql.mydomain.com 3306

(or change port you set different)


port 3306 open

more still does not work

I think there is a problem

hdavis84
Posts: 8
Joined: Sat Apr 29, 2017 7:55 pm

Re: HELP - Remote MySQL database server

Postby hdavis84 » Thu Aug 31, 2017 7:30 am

I'm having this exact problem as well. Patiently waiting to see this issue resolved.

hdavis84
Posts: 8
Joined: Sat Apr 29, 2017 7:55 pm

Re: HELP - Remote MySQL database server  Topic is solved

Postby hdavis84 » Thu Aug 31, 2017 9:35 am

Ok, so I have found something that worked for me. Apparently the remote database wouldn't let root login remotely on my mariadb server. So I created a user and granted all priveleges so it was basically root with a different name and then added the database with that login information. When I went to create a database using the remote database, it worked.

Hopefully this helps.


Return to “Database Server”



Who is online

Users browsing this forum: No registered users and 1 guest