![]() I imagine the exact list of allowed permissions may change with new versions of MySQL and over time, so hopefully this answer doesn't age too quickly.Įdit: Credit where credit is due - most of this I figured out thanks to this blog post on the issue. UPDATE, RELOAD, LOCK TABLES, REPLICATION SLAVE, REPLICATION CLIENT, CREATE TEMPORARY TABLES For that, I found I could specify all permissions EXCEPT CREATE TABLESPACE, FILE, SHUTDOWN, and SUPER globally: GRANT EXECUTE, PROCESS, SELECT, SHOW DATABASES, SHOW VIEW, ALTER, ALTER ROUTINE, CREATE, CREATE ROUTINE,ĭELETE, CREATE VIEW, INDEX, EVENT, DROP, TRIGGER, REFERENCES, INSERT, CREATE USER, Type '\c' to clear the current input statement.I had to use two GRANT queries to maximize permissions for a new user on RDS MySQL.Īs others have mentioned, this query grants full permissions to all databases except certain system databases (Note the `%` instead of *): GRANT ALL PRIVILAGES ON `%`.* TO my needs, I also needed as many permissions as possible on the systems tables (so this user could, for example, create new users). Other names may be trademarks of their respective Oracle is a registered trademark of Oracle Corporation and/or itsĪffiliates. ![]() Login to MySQL shell with newly created user and password. You can also view the allowed permission to a user in MySQL. * TO ' all priviledges to on specific database including permissions to grant other users. This instructions MySQL to apply these rights for use in the entire dbtest database. This does not include the privilege to use the GRANT command however. ALL PRIVILEGES - This tells it the user will have all standard privileges. mysql> GRANT SELECT,INSERT,DELETE ON dbname. GRANT - This is the command used to create users and grant rights to databases, tables, etc. * TO ' the following option to grant specific permissions like SELECT,INSERT,DELETE on a specific database to. Use the following option to grant all privileges on specific database to.
0 Comments
Leave a Reply. |