Things in Mysql / Check Port No / Create new user and give privileges / Different operations in MySQL / Reset root password

To find all the privileges given to an user in MySQL.

To know the privileges of an user, login to your MySQL with the user login details whose privileges you want to know and type this.

INPUT:     
show grants;  

OUTPUT:    
Grants for root@localhost     
GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION   
GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION    

The above output tells you that all the privileges has been given to the user “root”.

Another way to view the privileges given to an user is by typing this

INPUT:    
show grants for current_user;  

This also gives the same output as the earlier command.