HELP - Remote MySQL database server

[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?

[skurudo]

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)

[rogerio.dobler]

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

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.

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]

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

[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.