problem with conect to database from ANY IP

lolekserwer

Registered
Dec 15, 2006
1
0
151
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!:)
 

plexihosting

Member
Dec 16, 2006
13
0
151
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.