MySQL Forums
Forum List  »  Install & Repo

Re: ERROR 1045 - This works for me
Posted by: Jesus Rafael Lopez Ibarra
Date: April 28, 2011 03:38PM

Hi , well i saw the records on 'mysql' database table 'user' or 'users'? then i got three records of root, then i deleted two of them and set in the 'host' field the value '%'

then flush privileges and restart server, just in case.

mysql> delete from mysql.user where user like 'root' and (host = 'a ip number' or host = 'another ip number');

mysql> update mysql.user set host = '&' where user like ='root';

mysql> flush privileges;

BASH(fedora13)>> service mysqld restart

Options: ReplyQuote

Written By
June 27, 2009 08:29PM
Re: ERROR 1045 - This works for me
April 28, 2011 03:38PM
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.