error when acessing the Database

[pedroteixeira07]

Hi Everyone!

I really need help with this..
Everything was going OK with my DB and PHP...
Suddently I'm receiving this message:

#1142 - SELECT command denied to user 'pedrotei'@'localhost' for table 'Service_Pic'

Even if I try to make a query in the phpmyadmin I get that message.

The only thing that changed in terms of server was that I bought a new domain... and also I added a new database to the server. Other than that everything remained the same. Do you know how can I fix this?

The code is Ok because I've tested locally..

Thanks in advance!

[kiwibrit]

I'd contact your web-hosting company, and check that your MySQL username has full permissions to the database.

[sheephat]

You need to change the permissions of the user

[Bilbozilla]

From time to time this happens to me when my ISP changes my IP address. Make sure your IP is whitelisted so that you can access your database.