Question
Unable to connect to remote MySQL server
I am trying to connect to remote MySQL server from my local PC. I am getting “10061” error.
Here are the steps I followed:
- changed the
bind-address
in file/etc/mysql/mysql.conf.d/mysqld.conf
to the droplet ip. - GRANT ALL ON databasename.* TO user@xx.xxx.xx.xx IDENTIFIED BY ‘yourpassword’;
- flush privileges;
- sudo /etc/init.d/mysql restart
I have disabled firewall too. But still not able to connet to it. One more thing I have a live site using the same MySQL database, changing bind-address
to droplet IP makes the server throw Internal Server Error. Why is that ?
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
×