MySQL Forums
Forum List  »  Install & Repo

Re: ERROR 1045 - This works for me
Posted by: John Chang
Date: October 04, 2007 02:56AM

Trying to access MySQL (on Linux) with MySQL Query Browser (Windows) when I got a error 1045. Port was set to 3306. This is what works for me.

Use phymyadmin and access MySQL - the database where the grant tables are kept

Access 'user' table and browse it.

For me, I had two records with 'root' but under 'host' column - it was both 'localhost'

'localhost' - as per my understanding means client and server on same computer.

using phymyadmin, I changed one of the records to '%'

then I ran 'Flush Privileges' from the MySQL command

It works then

Options: ReplyQuote

Written By
June 27, 2009 08:29PM
Re: ERROR 1045 - This works for me
October 04, 2007 02:56AM
December 16, 2007 02:18AM
December 27, 2007 02:08PM
January 16, 2011 06:51AM
August 27, 2009 12:22AM

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.