Re: lost my privelleges?
Posted by:
Nick Roper
Date: August 30, 2004 12:06PM
Mark,
You say that you have PHP talking to MySQL, and also that you can access databases OK when you use mysql from the command prompt - presumably on the server.
The initial privileges allow you to connect as root with no password from the localhost server.
> I get Error 1142: select command denied fro user: root@localhost for table user etc!
Where are you running the select statement from when you get this error - are you using phpmyadmin or something?
Can you give the exact situations when you get errors.
Cheers,
Nick
--
Nick Roper
Subject
Written By
Posted
Re: lost my privelleges?
August 30, 2004 12:06PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.