HostOnNet Blog

Privileges Provided by MySQL

To find the privileges granted to a particular MySQL account

When we specify a particular MySQL account to check for privileges, use an account name constructed by user name and host name concatenated by “@”.

mysql> show grants for  'bizhat_forums'@'localhost';
+----------------------------------------------------------------------------------------------------------------------+
| Grants for bizhat_forums@localhost                                                                                   |
+----------------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'bizhat_forums'@'localhost' IDENTIFIED BY PASSWORD '*C8AA80B8A7829F6A56A1C2E75F35C29F2272FBA6' |
| GRANT ALL PRIVILEGES ON `bizhat_forums`.* TO 'bizhat_forums'@'localhost'                                             |
+----------------------------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)

mysql>

About Annie

I've been working in Technical Section for over 10 years in a wide range of tech jobs from Tech Support to Software Testing. I started writing blog for my future reference and useful for all.
Posted in MySQL