Outside MySQL/PHP Permission Issue

[Iyce]

Hello,

 

I'm running a quick PHP script that connects to a MySQL database with a limited user (only has access to one database). Now, the user's access rights is wildcarded currently so they should be able to log in anywhere; however, when I use this user to access the the database via a PHP script, the said user connects fine but cannot write or read from the DB properly. They have all access rights to this single DB, but nothing seems to be working. Any ideas?

 

Thanks,

Iyce

 

EDIT: Nevermind, figured it out. The problem was that my settings force me into ensuring a domain is set; I cannot use 'anywhere.'

[znx]

Wildcarding domains is always fun with MySQL and you should always be careful when doing it. Sometimes actually forcing single entries per domain is the best solution :)