?
Solved

Show Privileges for MYSQL User

Posted on 2014-08-11
2
Medium Priority
?
421 Views
Last Modified: 2014-08-12
Hi Experts,

How can I see what privileges are assigned to a MYSQL user?

Thanks
0
Comment
Question by:APD_Toronto
2 Comments
 
LVL 6

Accepted Solution

by:
Joseph Undis earned 2000 total points
ID: 40254123
Connect to your MYSQL database as the user you want to view permissions of and type the following in the MYSQL console:

SHOW GRANTS;

Open in new window


You can also do the same for a different user by typing the following:

SHOW GRANTS FOR [user];

Open in new window


e.x.

SHOW GRANTS FOR 'root'@'localhost';

Open in new window

0
 

Author Comment

by:APD_Toronto
ID: 40254347
What does the following mean?

-------------------------------+
| GRANT USAGE ON *.* TO 'chris'@'localhost' IDENTIFIED BY PASSWORD '*6C8989366EA
F75BB670AD8EA7A7FC1176A95CEF4' |
+-------------------------------------------------------------------------------
-------------------------------+

Open in new window


Also, is it normal to get duplicate users with

 select user from mysql.user;
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question