problem with conect to database from ANY IP

[lolekserwer]

hi!
I build some application which use dbExpress component to connecting with database.

and i've got a problem:

how from WHM/Cpanel/ssh establish Acces Hosts to any IP, because i want to that any of users (from any IP) can connect to DataBase. It's very important for me!

Now when I try to connectI can see that error

Acces denied fo user 'username'@'%' to database 'dbname'

please help me!

 

[ThinIce]

I believe you just use the wildcard % in the access hosts field

You'll still need to connect with a user with the right permissions etc

 

[plexihosting]

That should really be a last resort as it is a huge security hole. You should always grant as granular privileges as possible. This would even include not granting all privileges to users who don't need it. Adding % to access hosts is just asking for trouble in my opinion.