MySQL Forums
Forum List  »  PHP

Re: creating database users
Posted by: Barry Galbraith
Date: December 19, 2012 03:08PM

> drop the user then create it before granting access to it.

Doesn't matter.

>"grant ALL on ".DATABASE_NAME.".* to '".$usn."'@'localhost';";// identified by password '".$pwd."';";// with grant option


The GRANT OPTION allows this user grant privileges to other users, and shouldn't normally be on any user other than root

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
December 19, 2012 05:43AM
December 19, 2012 07:42AM
Re: creating database users
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.