HELP - Remote MySQL database server
-
- Posts: 10
- Joined: Tue Jul 15, 2014 1:34 pm
HELP - Remote MySQL database server
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:
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:
will be where did I go wrong?
Can someone help me?
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
Code: Select all
→ Error: Connection to mysql.mydomain.com failed
Can someone help me?
Re: HELP - Remote MySQL database server
Resolving or Portrogerio.dobler wrote:will be where did I go wrong?Code: Select all
→ Error: Connection to mysql.mydomain.com failed
resolv check ->
Code: Select all
ping mysql.mydomain.com
Code: Select all
telnet
Code: Select all
open mysql.mydomain.com 3306
-
- Posts: 10
- Joined: Tue Jul 15, 2014 1:34 pm
Re: HELP - Remote MySQL database server
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.
port 3306 openskurudo wrote:(or change port you set different)Code: Select all
open mysql.mydomain.com 3306
more still does not work
I think there is a problem
Re: HELP - Remote MySQL database server
I'm having this exact problem as well. Patiently waiting to see this issue resolved.
Re: HELP - Remote MySQL database server
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.
Hopefully this helps.