CODEWITHSUNDEEP
mysql-workbench
Stephen Bouffe
Stephen Bouffe

Reputation: 517

MYSQL limit hosts matching with a domain name

In MySQL workbench I have an account setup for connections and I would like to limit connections.

I'm using dynu dns and have setup a domain like br1.mydomain.com which points to the ip of our office which in turn needs to connect to the db

Workbench lets me enter that in the section "Limit to hosts matching" but when I try to connect it's refused.

Upvotes: 0

Views: 2002

Answers (1)

Mike Lischke
Mike Lischke

Reputation: 53532

Right, if the IP address changes dynamically you would have to update the user account constantly. However, it's possible to use wildcards for the host field. Still I would not rely on that as it might also give you some grief when adding more users and/or switching clients to connect from (e.g. a different ISP).

A much safer concept is to create an SSH tunnel and connect over that. Even for Windows there are free SSH servers available (*nix/macOS platforms already come with an SSH server).

Upvotes: 1

Related Questions