![]() The new user now has the same permissions as the admin account. ![]() ![]() Permissions might change across different major versions of MySQL mysql> GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, PROCESS, REFERENCES, INDEX, ALTER, SHOW DATABASES, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT, TRIGGER ON *.* TO WITH GRANT OPTION TO 'root''' sudo systemctl restart mysql. Note: The following permissions apply to MySQL 5.7. The correct solution is to grant the root user (or another user) remote access since root comes only with localhost access: sudo mysql -u root -p CREATE USER 'root''' IDENTIFIED BY '1234567890' GRANT ALL PRIVILEGES ON. Run the GRANT command to grant the list of permissions that you got in step 2 to the new user: Note: Replace new_admin_user and password with your user name and password.Ĥ. Create a new user with the CREATE USER command: mysql> CREATE USER IDENTIFIED BY 'password' Note: In this case, the admin account has the user name admin.ģ. | GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, PROCESS, REFERENCES, INDEX, ALTER, SHOW DATABASES, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT, TRIGGER ON *.* TO WITH GRANT OPTION | You see an output that's similar to the following message: +-+ Then, copy that list of permissions to use later: mysql> SHOW GRANTS for admin_username Run the SHOW GRANTS command to get a list of the permissions that are currently available to the admin account. To create a new user with these permissions, complete the following steps:Ģ. However, you can create a new user that has all the same permissions as the admin account. By default, an RDS DB instance that runs MySQL has one admin account.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |