MySQL Forums
Forum List  »  MySQL Administrator

Re: MYSQL USER ACCESS ISSUE
Posted by: Scott Nemes
Date: November 27, 2012 01:14PM

The likely issue is that MySQL is using a record from the grant table that you are not expecting it to (specifically ''@'vmlnx3').

Try removing the record with the hostname of "vmlnx3" and no user, making sure to flush privileges after, and then try to login again using "mysql -uprash -pprash -hvmlnx3" as you did previously. Currently ''@'vmlnx3' is likely the record that is getting used by MySQL, and is why you are getting the access denied error. Once that record is gone, the next one that should match is 'prash'@'%'.

The way that MySQL processes the grant tables in memory can result in unexpected behavior if you are not familiar with the way it works. Below is a great read from the MySQL manual which explains this process:

http://dev.mysql.com/doc/refman/5.5/en/connection-access.html

--
Scott Nemes
MySQL DBA

http://www.linkedin.com/in/scottnemes
http://www.twitter.com/ScottNemes

Options: ReplyQuote


Subject
Written By
Posted
November 27, 2012 06:38AM
Re: MYSQL USER ACCESS ISSUE
November 27, 2012 01:14PM
November 28, 2012 06:59AM


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.