[RndTbl] My MySQL battle
Robert Keizer
robert at cluenet.org
Tue Mar 16 13:40:45 CDT 2010
Raymond J. Henry wrote:
>
> OK, I’ve come to the conclusion that I’m doing something wrong, but
> can’t for the life of me figure out what it is. Going over and over
> and over documentation, I must be interpreting something wrong,
> because I think I’m doing what it says.
>
> I’m setting up a new box with CentOS. Installed MySQL, and it’s
> running. Now I get to setting the password. Here’s the issue.
>
> I start with:
>
> mysqladmin -u root password SQLROOTPASSWD.
>
> No problem
>
> Then I try:
>
> mysqladmin -h myserver.mydomain.com -u root password SQLROOTPASSWD.
>
> This is where things go South. I get the response
>
> mysqladmin: connect to server at ‘(my server)’ failed
>
> “Access denied for user ‘root’@’192.168.1.160’ (using password: NO)’
>
> I’m at a loss. Hours of fighting with this, and I’m nowhere….. Help?
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> Roundtable mailing list
> Roundtable at muug.mb.ca
> http://www.muug.mb.ca/mailman/listinfo/roundtable
>
Your problem is that MySQL stores permissions based not only on users,
but also where they're coming from.
Try in the mysql console "grant all privileges on *.* to
'root'@'192.168.1.160' IDENTIFIED BY '<yourpasswordhere'" followed by a
flush privileges.
All the best,
Robert
More information about the Roundtable
mailing list