We are happy to announce that Vesta is back under active development as of 25 February 2024. We are working on v1 candidate and expect to engage more with the community over the coming months. We are committed to open source, and we encourage contributors to help us build the future of Vesta.
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.