MySQL Forums
Forum List  »  MySQL Workbench

Re: Not able to connect to server
Posted by: Mike Lischke
Date: May 07, 2014 01:08AM

Nikos Skatz Wrote:
-------------------------------------------------------
> OK.
> It worked now.
> I also put the line bind-address=0.0.0.0 in my.cnf
> and I can connect using the local ip (192.168.2.4)
> instead of localhost.

0.0.0.0 is the default for bind-address, you haven't changed anything (https://dev.mysql.com/doc/refman/5.6/en/server-options.html#option_mysqld_bind-address). Don't mess with bind-address unless you know what you are doing. It's usually not necessary to change that value.

> Actually I'm planning to install mysql workbench
> in windows and manage mysql from there. Do I have
> to change anything else? (instead of iptables -
> perhaps)

Watch this video for troubleshooting tips: https://www.youtube.com/watch?v=DCgRF4KOYIY&list=PLWx5a9Tn2EvHpwpyDa2oJczpK0ojwJpM5. Especially keep in mind that your firewalls must allow traffic for the used MySQL port (default = 3306).

Mike

Mike Lischke, MySQL Developer Tools
Oracle Corporation

MySQL Workbench on Github: https://github.com/mysql/mysql-workbench
On Twitter: https://twitter.com/MySQLWorkbench
On Slack: mysqlcommunity.slack.com (#workbench)
Report bugs to http://bugs.mysql.com
MySQL documentation can be found here: http://dev.mysql.com/doc/refman/8.0/en/

Options: ReplyQuote


Subject
Views
Written By
Posted
2875
May 04, 2014 02:44PM
Re: Not able to connect to server
782
May 07, 2014 01:08AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.