MySQL Forums
Forum List  »  PHP

Re: creating database users
Posted by: Barry Galbraith
Date: December 19, 2012 05:43AM

You have an anonymous user at localhost, with no password, with USAGE privilege only. IOW anonymous@localhost can connect, without a password, but can't do anything.

user BOREHOLES@% doesn't get seen when BOREHOLES logs in from localhost, because it's being masked by the anonymous@localhost, and can only login without a password.

So, you can do either (or both) of 2 things.
DROP user ''@'localhost';
FLUSH PRIVILEGES;
This will prevent BOREHOLES@localhost matching anonymous@localhost.

And / or
GRANT ALL on boreholes.* to 'BOREHOLES'@'localhost' IDENTIFIED BY PASSWORD 'boreholes_password';
FLUSH PRIVILEGES;
Specify the hostname that BOREHOLES can connect from.

Good luck,
Barry.

Options: ReplyQuote


Subject
Written By
Posted
December 18, 2012 02:15AM
December 18, 2012 02:22AM
December 18, 2012 11:31AM
December 19, 2012 01:01AM
December 19, 2012 01:07AM
December 19, 2012 02:19AM
Re: creating database users
December 19, 2012 05:43AM
December 19, 2012 07:42AM
December 19, 2012 03:08PM


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.