Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

How to check my privileges?

Tags:

sql

mysql

How check my user privileges?

I am interested in privileges create user or grant privileges any users.

like image 233
Mediator Avatar asked Dec 23 '10 16:12

Mediator

1 Answers

You can check the privileges of the current user by running

SHOW GRANTS;

Or the privileges of ANY user by running

SHOW GRANTS FOR 'user'@'host'

Yay docs!

like image 89
TehShrike Avatar answered Nov 17 '22 18:11

TehShrike
Sign in to Comment

Related questions

Does MySQL view always do full table scan?
How to fix Server Status Code: 302 Found by SQL Inject Me Firefox Addon
Most efficient way to find the closest integer in MySQL?
SQL: Insert only new rows/records into a table?
Export structure and data (like in PhpMyAdmin)
Database design of a tree-like category system
If an PHP PDO transaction fails, must I rollback() explicitely?
Is there any good reasons that I should not use - (dash) in field names in MySQL?
Reorder integer except for value 0 with sql
SQL Max Question
Selecting an item matching multiple tags
Creating a linked list or similar queue in MySQL?
How can a PHP PDO object figure out if it's already in a MySQL Transaction?
INSERT INTO SELECT,copy value+ 'string'
Rails - See generated SQL queries in Log files
MySQL - Searching with UNION ALL and GROUP BY
Getting the actual (absolute) execution time of the last query in PHP (excluding network latency etc)
MYSQL Select to file
When to use 1 to 1 tables in databases
how to write Regular Expression in MySQL select queries?

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!