Share

Question

I have already a sistem loaded on digital ocean using a mysql database and is working perfectly, but the problem is that i can’t connect using mysqlworkbench to the database and i getting the error Can’t Connect to MySQL Server on IPAddress (10061)

Im new using this services of digital ocean, so i don’t know what is wrong on my settings to access the database. (which is actualy working for the system).

I don’t know what to configure over the mysqlworkbench to access the database:

1)Shall I use a tcp/ip or tcp/ip / ssh ??

Thanks for your support
Rgds

Answer 1

ryanpq January 8, 2015

By default MySQL will listen for connections only from the local host. To enable remote connections like the one used by mysqlworkbench you will need to modify your /etc/my.cnf and change

bind-address 127.0.0.1

to

bind-address 0.0.0.0

or simply comment out the line completely. Once this is done, restart MySQL with the command

service mysql restart

and you should be able to make your connection.

Reply Report

aksun September 21, 2017

If the mysql reboot doesn’t solve the issue, try rebooting the whole system instead.
Reply Report
afriza October 14, 2018
For MariaDB 10.1 under Ubuntu 18.04.1

bind-address 127.0.0.1

is located at /etc/mysql/mariadb.conf.d/50-server.cnf
Reply Report
- marciozotelli January 21, 2019
  
  Tks!
  
  Reply Report
- williamdiaz102 November 21, 2019
  
  For mysql on ubuntu 18.04 you can find the .cnf file under /etc/mysql/mysql.conf.d/mysqld.cnf
  
  Reply Report

Answer 2

aksun September 21, 2017

If the mysql reboot doesn’t solve the issue, try rebooting the whole system instead.
Reply Report
afriza October 14, 2018
For MariaDB 10.1 under Ubuntu 18.04.1

bind-address 127.0.0.1

is located at /etc/mysql/mariadb.conf.d/50-server.cnf
Reply Report
- marciozotelli January 21, 2019
  
  Tks!
  
  Reply Report
- williamdiaz102 November 21, 2019
  
  For mysql on ubuntu 18.04 you can find the .cnf file under /etc/mysql/mysql.conf.d/mysqld.cnf
  
  Reply Report

Answer 3

kumaranilanil29 December 20, 2017

Need to reconfigure the my-sql server. i used “mysql-installer-community-5.7.20.0” to reconfigure the server. and now it is working well. If “MySQL57” will looks in windows services. then it will work properly. Installer community will restart the server or you can also restart manually by below flow

Step-1-> Open Run or type Run in task-bar search of window and press Enter
Step-2->Type “services.msc” in Run and press Enter
Step-3->Search “MySQL57” in windows services
Step-4->If server is not running then Right click on mouse button and click on Start.

Before doing this need to reconfigure the mySql server for removing “Can’t Connect to MySQL Server on IPAddress (10061)”

If “MySQL57” is not looking on windows services then you should need to reconfigure again.if it will shows in services then it will work properly.

Reply Report

brainssage August 23, 2019
Hello,

I got this error even after I put the Mysql port 3306 open access. The firewall should be allowing connections. Tried to change the bind address of my.cnf mysql file but in vain. Here’re the suggested solutions:

https://stackoverflow.com/questions/3518845/cant-connect-to-mysql-server-on-10061-ipaddress-
edited by jamonation
Reply Report

Answer 4

brainssage August 23, 2019
Hello,

I got this error even after I put the Mysql port 3306 open access. The firewall should be allowing connections. Tried to change the bind address of my.cnf mysql file but in vain. Here’re the suggested solutions:

https://stackoverflow.com/questions/3518845/cant-connect-to-mysql-server-on-10061-ipaddress-
edited by jamonation
Reply Report

Answer 5

williamdiaz102 November 21, 2019

[deleted]

Reply Report

Question

Can't Connect to MySQL Server on IPAddress (10061)

Leave a comment

Looking for something else?

Share

Share your Question

Question

Can't Connect to MySQL Server on IPAddress (10061)

Leave a comment

Looking for something else?

Almost there!