MySQL - Explain how to view and Revoke user privileges in MySQL

Explain how to view and Revoke user privileges in MySQL.

View user privileges

Privileges assigned to users can be viewed using the SHOW GRANTS USER_NAME command.
Example:
SHOW GRANTS for sampleuser;

Revoke user privileges

Privleges assigned can be revoked using REVOKE PRIVELEG_NAME
Example:
REVOKE CREATE ON *.* FROM sampleuser;
MySQL - Explain the command line options offered by mysqld
Explain the command line options offered by mysqld - --help - Displays a short help message on how to use mysqld, --verbose --help - Displays a long help messages on how to use mysqld.....
MySQL - What is Binary Log File in MySQL?
What is Binary Log File in MySQL? - The binary log file contains information about statements that could have modified the data and how long it took to modify the data.....
MySQL - Explain how to run MySQL Server on a different Port.
Explain how to run MySQL Server on a different Port - By default, MySQL will listen at port number 3306 for any client connections......
Post your comment

Related Content

Follow us

▲