Page 1 of 1

HELP - Remote MySQL database server

Posted: Wed Aug 31, 2016 11:36 pm
by rogerio.dobler
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?

Re: HELP - Remote MySQL database server

Posted: Thu Sep 01, 2016 6:39 am
by skurudo
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)

Re: HELP - Remote MySQL database server

Posted: Thu Sep 01, 2016 2:12 pm
by rogerio.dobler
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

Re: HELP - Remote MySQL database server

Posted: Thu Aug 31, 2017 7:30 am
by hdavis84
I'm having this exact problem as well. Patiently waiting to see this issue resolved.

Re: HELP - Remote MySQL database server

Posted: Thu Aug 31, 2017 9:35 am
by hdavis84
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.