By tijacque
Olá estou tentando realizar o conexão remota entre um banco de dados digitalOcean e um site hospedado em outro servidor, informei o IP da hospedagem, configurei o banco para versão legada, criei usuário e senha mas a conexão só funciona na minha máquina, que foi configurada da mesma forma, no cliente (servidor Hostgator) dá erro na conexão 2002. como posso solucionar? obs configurei ip da minha maquina e também da hospedagem ok
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
Hello, @tijacque
You can make sure that the database is running before doing another connection attempt from the 3rd party hosting provider.
Make sure to double check the database credentials and also verify that the external host can make outgoing connections on the specified port as well.
Hope that this helps! Regards, Alex
Hi @tijacque,
The error (2002) Can’t connect to … normally means that there is no MySQL server running on the system or that you are using an incorrect Unix socket file name or TCP/IP port number when trying to connect to the server. You should also check that the TCP/IP port you are using has not been blocked by a firewall or port blocking service.
https://dev.mysql.com/doc/refman/5.6/en/can-not-connect-to-server.html
I will suggest you check with Hostgator and see if there is any firewall blocking this droplet.
For information on Hostgator MySQL database connection issues: https://www.hostgator.com/help/article/troubleshooting-mysql-database-connection-issues
I hope this helps!
Regards, Rajkishore
Become a contributor for community
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
DigitalOcean Documentation
Full documentation for every DigitalOcean product.
Resources for startups and SMBs
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
The developer cloud
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Get started for free
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.