MySQL Forums
Forum List  »  MySQL Query Browser

Re: MySQL error number 1130
Posted by: Peter Granger
Date: August 08, 2008 06:29PM

Ronald Swanepoel Wrote:
-------------------------------------------------------
> I had the same problem, but after I reconfigured
> the instance, and checked the Enable root access
> from remote machines, it worked.

I'm looking for someplace to check "Enable root access from remote machines." Is that in the MySQL Admin GUI? I haven't been able to find it. Might be a version issue -- I'm running 1.2.5rc (newest version found by package manager...don't ask).

I went into the settings in the Admin, and even though I didn't save any changes after looking around in there, the error I'm getting has now changed to

ERROR 1045 (28000): Access denied for user 'root'@'mymachinename.mycompany.com' (using password: YES)

Is this perhaps best solved by giving "root" only local permission, and creating other users with access from anywhere? That seems to be working for me -- and it makes sense, I should only be root on my local machine.

Since root was the first login I'd tried, I'd assumed that this was indicating a problem with all users, and hadn't realized that it was more due to the special status of root.



Edited 1 time(s). Last edit at 08/08/2008 06:34PM by Peter Granger.

Options: ReplyQuote


Subject
Written By
Posted
January 07, 2006 09:02AM
January 09, 2006 02:19AM
July 07, 2006 01:01PM
September 07, 2006 09:05AM
November 28, 2006 06:59PM
March 16, 2008 12:30PM
October 14, 2007 02:26AM
August 02, 2008 05:06AM
October 16, 2007 12:32AM
November 12, 2007 05:58AM
December 21, 2007 01:32AM
Re: MySQL error number 1130
August 08, 2008 06:29PM
January 01, 2008 06:33AM


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.