Sample Header Ad - 728x90

MySQL User with Host set to a Range of IP Addresses

16 votes
4 answers
61269 views
I have a hosted MySQL DB that I need to give access to from my customers site. They have a fast broadband connection which can present them with a range of IP addresses from a fixed pool. So I need to lock down the access to their MySQL user so that the Host setting is a range of addresses within a class. Not the whole class. I realise I can use a wildcard such as 81.91.71.% but that is too generous. Their range is more like 81.10.20.1 --> 81.10.20.15 Is there a way to do this other than create 15 users, one for each individual IP address? thanks Mark
Asked by Mark Ogier (313 rep)
Aug 30, 2013, 07:20 AM
Last activity: Feb 12, 2025, 04:38 AM