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/