Re: MySQL error number 1130
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.
Subject
Written By
Posted
September 07, 2006 09:05AM
November 28, 2006 06:59PM
November 12, 2007 05:58AM
December 21, 2007 01:32AM
Re: MySQL error number 1130
August 08, 2008 06:29PM
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.