HELP - Remote MySQL database server Topic is solved

Questions regarding the Database Server
MySQL, PostgreSQL, MariaDB, Percona Server, phpMyAdmin, phpPgAdmin
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: 7798
Joined: Fri Dec 26, 2014 2:23 pm
Location: Moscow
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 4 guests

cron