MySQL Forums
Forum List  »  PHP

Advanced Search
New Topic

Re: Minimum privileges to create a user, then a database, and then grant permissions
Posted by: Peter Brawley
Date: December 06, 2019 03:35PM

"To use GRANT, you must have the GRANT OPTION privilege, and you must have the privileges that you are granting. When the read_only system variable is enabled, GRANT additionally requires the CONNECTION_ADMIN or SUPER privilege." https://dev.mysql.com/doc/refman/8.0/en/grant.html

So your code will need to ensure that the login under which the code is running has at least the privs that the code will grant.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Minimum privileges to create a user, then a database, and then grant permissions
Walter Oney
December 05, 2019 07:24PM
Re: Minimum privileges to create a user, then a database, and then grant permissions
Peter Brawley
December 06, 2019 01:02PM
Re: Minimum privileges to create a user, then a database, and then grant permissions
Walter Oney
December 06, 2019 02:42PM
Re: Minimum privileges to create a user, then a database, and then grant permissions
Peter Brawley
December 06, 2019 03:35PM


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.