MySQL said: select command denied to user: 'root@

surendran · February 3rd, 2006, 07:27 AM

Hi friends,
i'm getting one error says MySQL said: select command denied to user: 'root@localhost' for table 'xxxxxxxx'

not only this erro even i can not access any tables in the databse,

i'm using 3rd party web tool for access, unix server....

u know it was working fine suddnlly i click GRANT or REVOKE (can not remember) after that this was happen, even i can not do anything,
please help me

surendran
(Anything is Possible)

panacea · February 13th, 2006, 05:56 AM

Hmm, are you sure that you have access to the root user? Perhaps your MySQL user on your 3rd party web host is the same as the user you use for FTP, etc. Can you use a mysql client locally to connect to the hosted server using your assumed credentials?

Jon Emerson
http://www.jonemerson.net/

janHolland · September 9th, 2010, 12:27 AM

Quote:

Originally Posted by surendran

Hi friends,
i'm getting one error says MySQL said: select command denied to user: 'root@localhost' for table 'xxxxxxxx'

not only this erro even i can not access any tables in the databse,

i'm using 3rd party web tool for access, unix server....

u know it was working fine suddnlly i click GRANT or REVOKE (can not remember) after that this was happen, even i can not do anything,
please help me

surendran
(Anything is Possible)

Writing a new small program
I ran on the same errormessage by
mysql_query("SELECT fields FROM dbame.tablename")

The solution proved to be in
another=better formulation of the mysql_query:
mysql_query("SELECT fields FROM tablename").

mysql_query("SELECT fields FROM dbame.tablename")