MySQL select command denied to user error

lsimon4180 · 03-03-2005, 05:57 PM

Hi,

I am running Fedora 2 with MySQL 3.23 and I am getting the following error when trying to access a table in a php/mysql script:

select command denied to user: 'user1@server' for table 'table_name'

I add the approriate user and applied all priviliages to it but I still get this error.

Any suggestions?

Lenny

andrewlkho · 03-03-2005, 06:25 PM

Umm.. you sure that you added the correct privileges? Also, have you flushed the privileges?

lsimon4180 · 03-03-2005, 06:34 PM

yeah im using phpmyadmin and selected "grant all privliges" so i guess that it would apply all of them. How do you flush them though, im phpmyadmin and command line? If you know.

thanks,

lenny