Grant access to mysql database from ALL hosts.

NodeWorx General Discussion
1

Hi,

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.

Thanks,

2

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.

3

That’s EXACTLY what I wanted.

Thanks!