HELP - Remote MySQL database server
Posted: 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:
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?