MySQL Forums
Forum List  »  Newbie

Re: Different Visible Databases for each User
Posted by: Barry Galbraith
Date: February 23, 2014 03:13PM

There could be other rows in mysql.users table that are catching your login.
Try this to see which row your user login is being identified as.

Login as shy, then
mysql>SELECT user(), current_user();

user() will show you the user@host that your client login supplied, current_user() will show you row it matched in mysql.users table. They should be the same.
It's possible you are being identified as anonymous user. If you are, then anonymous user will need to be removed.

Good luck,
Barry.

Options: ReplyQuote


Subject
Written By
Posted
Re: Different Visible Databases for each User
February 23, 2014 03:13PM


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.