Ubuntu 14 (CLI only) and mysql 5.6

Server Config
1

Hello, all,

I’m trying to set up mysql on Ubuntu Server 14 (CLI, no GUI) and I think I’ve got that much done; however, I’m having difficulty connecting to it from another computer running Workbench. So, I’m guessing that it’s a configuration issue.

Whenever I try to log on to the mysql via my Windows7 system (there are no firewalls - this is an internal network), I get an error message that ‘{ip address} cannot connect to this MySQL database (PASSWORD: YES)’. I’ve tried searching via Google, but I’m not finding much in the way of advice on fixing this. Any help appreciated.

V/r,

:slight_smile:

2

Check your my.cnf /etc/mysql/my.cnf, there is a line in there called bind-address, it is probably sent to 127.0.0.1, you want to change it to 0.0.0.0

Then restart the service

3

I had changed it to the IP address of the Ubuntu server. What does changing it to all zeroes do?

V/r,

:slight_smile:

4

Lets other IPs connect to it. The problem is you want other IPs connecting to it, not just the server. By setting it to the server, you are saying, that server can only connect to.

http://stackoverflow.com/questions/15663001/remote-connections-mysql-ubuntu

1 Like
5

Thanks for the link, cpradio. I’ll give that a shot after I get home from work, tonight.

V/r,

:slight_smile:

6

Tah-dah! Thanks, @cpradio. That was the trick.

V/r,

:slight_smile:

1 Like
7

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.