- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
What MySQL databases do I have permissions on?
To check this, you can use SHOW command. The syntax is as follows −
show grants\G
Let us implement the above syntax to display the permissions you have −
mysql> SHOW GRANTS\G
This will produce the following output −
*************************** 1. row *************************** Grants for root@%: GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, SHUTDOWN, PROCESS, FILE, REFERENCES, INDEX, ALTER, SHOW DATABASES, SUPER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT, TRIGGER, CREATE TABLESPACE, CREATE ROLE, DROP ROLE ON *.* TO `root`@`%` WITH GRANT OPTION *************************** 2. row *************************** Grants for root@%: GRANT BACKUP_ADMIN,BINLOG_ADMIN,CONNECTION_ADMIN,ENCRYPTION_KEY_ADMIN,GROUP_REPLICATION_ADMIN, PERSIST_RO_VARIABLES_ADMIN,REPLICATION_SLAVE_ADMIN,RESOURCE_GROUP_ADMIN,RESOURCE_GROUP_USER,ROLE_ADMIN,SET_USER_ID, SYSTEM_VARIABLES_ADMIN,XA_RECOVER_ADMIN ON *.* TO `root`@`%` 2 rows in set (0.00 sec)
Updated on 30-Jul-2019 22:30:25
- Related Questions & Answers
- MySQL permissions to view all databases?
- What are the things I have to do every morning when I wake up?
- What I have to do to participate in the Miss World contest?
- How can we check the default character sets of all the MySQL databases we have on the server?
- How do I select data that does not have a null record in MySQL?
- I have a unique startup idea, but don’t know where to start? What should I do?
- Getting root permissions on a file inside of vi on Linux
- How can I view the indexes I have set up in MySQL?
- What are the different MySQL prompts we have on the command line?
- How can I restore multiple databases or all databases dumped by mysqldump?
- How do I remove ON UPDATE CURRENT_TIMESTAMP from an existing column in MySQL?
- How do I multiply an unsigned int by -1 on a MySQL SELECT?
- How do I declare global variables on Android?
- How do I see what a MySQL view is made of?
- How can I get a list of databases and collections on a MongoDB server?
Advertisements