cant seem to find where or how i define remote hosts that are allowed to access my MySQL databases.
am i missing it somewhere?
On the screen where you grant DB permissions ti a DB user there is a field saying “when connecing from” – the default is localhost but you can also specify an IP address or a list of IP addresses.
how do i delimit multiple addresses,
does it use a , or a ; or something like that?
comas and a space between them should do.
thanks i will try that out
Whoops, looks like I was mistaken – you have to add a separate user with a separate IP for each IP you want to add.
gotcha… ok, will try that
[QUOTE=IWorx-Tim;9628]Whoops, looks like I was mistaken – you have to add a separate user with a separate IP for each IP you want to add.[/QUOTE]Can you use wildcards? Like 192.168.. or similar?
You can use the % wildcard as farm as I am aware.
I don’t know about partial wildcards though - not something I’ve ever been asked for.
Looks like it, I was able to successfully add a user using your example to a database without it erroring it out.
It won’t error out with wildcards, but it won’t do you much good when connecting remotely via a MySQL GUI (e.g. SQLYog) – you can “access” the MySQL server, but you are not able to connect to a database as far as I can tell…
Drag on my end as the IP keeps changing with this damn DSL connection – a few times a day I have to add in the new IP address to the MySQL remote user.
Wildcard would be perfect if it could work, lol.
If anyone knows how to pull off wilcard style remote IP entries, let me know!
Thanks…
[quote=newmind;14798]It won’t error out with wildcards, but it won’t do you much good when connecting remotely via a MySQL GUI (e.g. SQLYog) – you can “access” the MySQL server, but you are not able to connect to a database as far as I can tell…
Drag on my end as the IP keeps changing with this damn DSL connection – a few times a day I have to add in the new IP address to the MySQL remote user.
Wildcard would be perfect if it could work, lol.
If anyone knows how to pull off wilcard style remote IP entries, let me know!
Thanks…[/quote]
As EverythingWeb wrote in 2006, use % for wildcards.
If you are able to connect but get an access denied error, make sure you don’t have an anonymous login entry ( ‘’@localhost ) which will take precedence over a wildcard entry such as username@%
Awesome, EverythingWeb.
I was using * and not % as the wild card char.
% does the job nicely ;–)