MySQL Forums
Forum List  »  Install & Repo

Re: lost my privelleges?
Posted by: Nick Roper
Date: August 30, 2004 12:06PM


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.



Nick Roper

Options: ReplyQuote

Written By
August 30, 2004 04:27AM
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.