How can I show user’s privileges in MySQL?

The command SHOW GRANTS [FOR user] is what you’re looking for. See here for more detail.

Related Posts:

  1. What are the recommended database permissions for WordPress?
  2. Problem with admin login after deployment
  3. Find out how many times the user has logged in
  4. Extract all users along with yoast metadata description
  5. Custom user query – orderby meta_key (that may not exist)
  6. Changing host permissions for MySQL users
  7. Column count doesn’t match value count at row 1
  8. ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
  9. MySQL string replace
  10. Which MySQL data type to use for storing boolean values
  11. ERROR 2003 (HY000): Can’t connect to MySQL server on localhost (10061)
  12. Cannot delete or update a parent row: a foreign key constraint fails
  13. Your password does not satisfy the current policy requirements
  14. MySQL: Access denied for user ‘test’@’localhost’ (using password: YES) except root user
  15. What is the definition of cardinality in SQL
  16. How to restart remote MySQL server running on Ubuntu linux?
  17. Host ‘xxx.xx.xxx.xxx’ is not allowed to connect to this MySQL server
  18. PHP Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP
  19. Selecting data from two different tables without using joins
  20. Difference between VARCHAR and TEXT in MySQL
  21. MySQL: Invalid use of group function
  22. How can I loop through all rows of a table? (MySQL)
  23. Simple Random Samples from a Sql database
  24. What does SQL clause “GROUP BY 1” mean?
  25. LAST_INSERT_ID() MySQL
  26. SQL select only rows with max value on a column
  27. Trying to perform MINUS operation in MySQL
  28. How do I find which transaction is causing a “Waiting for table metadata lock” state?
  29. mysql count duplicates
  30. phpmyadmin #1045 Cannot log in to the MySQL server. after installing mysql command line client
  31. MySQL config file location – redhat linux server
  32. Create boolean column in MySQL with false as default value?
  33. Is there a naming convention for MySQL?
  34. Error Code 1292 – Truncated incorrect DOUBLE value – Mysql
  35. MySql – HAVING vs WHERE 
  36. How to stop mysqld
  37. Is merge statement available in MySQL
  38. GROUP_CONCAT comma separator – MySQL
  39. Set page template for all pages?
  40. Optimize Multiple Taxonomy Term MySQL Query?
  41. WordPress MySQL & PHP Performance
  42. What specific database privileges does WordPress need?
  43. How can I add a user through SQL?
  44. Using source control with WordPress
  45. My WordPress site always displays a cached version of its homepage
  46. Updating User Meta with SQL Query
  47. wpdb prepare syntax
  48. Reapproval for edits and deletion after post is published
  49. How to run this SQL query of wp_terms database
  50. Is there a simple way to manage capabilities per user?
  51. Proper way to work with wpdb to get user’s firstname
  52. How to change post format from Aside to Image for all posts?
  53. SQL User Query by Multiple Roles using PHP
  54. Inserting Hundreds of Thousands of Posts at Once
  55. wp_admin edit.php slow with lots of queries
  56. How to add and SQL query of posts only published
  57. Slow Mysql Queries
  58. can database and media folder be moved to a different drive?
  59. Find duplicate posts with same slug and author
  60. Select Multiple meta_value from WP DB; Single Query
  61. How do I customize the dashboard?
  62. writing inner join in wpdb
  63. How to get data from WordPress site sql file
  64. Unknown collation when I import a dump from an existing site into a development database?
  65. PHP script can’t connect to Database on port 3307
  66. WordPress with php5-fpm and nginx
  67. When WordPress Default table, Echo Success. When Plugin Table, Echo Blank
  68. I am getting mysql_real_escape_string() function error while adding user?
  69. How to translate this mySQL query to $wpdb query
  70. $wpdb to insert html form information
  71. MySQL 5.5 upgrade ‘broke’ WordPress [closed]
  72. Hide images from anonymous user?
  73. Separate DB by yearly archive of WordPress
  74. What should a WordPress developer know about MySQL? [closed]
  75. Copyright: Get first and last date of post type
  76. Update MySQL query so that it functions again
  77. Query posts by custom taxonomy and sort by post_modified
  78. WordPress $wpdb get posts from category and sort by custom meta
  79. Array Formation Issue
  80. Migration problems with mysql: Operation not allowed when innodb_forced_recovery > 0 [closed]
  81. Preventing role reading others posts
  82. WordPress $wpdb no result
  83. Delete all users with Editor role and their content mysql
  84. when using $wpdb sudden connection rejection without changing anything. Access denied, with errors from repair tool
  85. Show posts who published after registration date
  86. edit_user_created_user hook – using to update Groups
  87. Mysql Error in querying form entries in Gravity Form plugin
  88. Improving performance of SQL sub-queries in WordPress
  89. How to set max users to 17.000
  90. Saving custom term value to the database in new table
  91. MySQL errors after a WordPress clone
  92. MYSQL Join on meta key value?
  93. Complicated MySQL Query
  94. problem with quotes on new post
  95. How to give access to the particular page in wordpress for specific username/email NOT roles [closed]
  96. Need SQL query to find&replace image URL
  97. MySQL query to list users who never signed in
  98. How do I share a Git repository with multiple users on a machine?
  99. InnoDB: Error: log file ./ib_logfile0 is of different size
  100. Postgres equivalent to MySQL’s \G?

Leave a Comment