Grant access to mysql database from ALL hosts.


Which is the correct syntax to grant access to ALL hosts to a certain database?
I’m in the Siteworx/Mysql/Databases page and I want a certain database to be accesible from all outside hosts to do some testing.

I normally give access to “localhost” or a certain IP, but never to ALL IPs.


Select the user, set the permissions and then enter


in the ‘When connecting from’ box. This will allow access to the mySQL database in question, from any remote host.

That’s EXACTLY what I wanted.