In this article, we will find how to show user privileges in MySQL.
We can check the privileges granted to user in MySQL by using command show grants command.
In this article, we will find how to show user privileges in MySQL.
We can check the privileges granted to user in MySQL by using command show grants command.
In this article, we will see how to get list of databases in MySQL. We can get list of databases in MySQL server using SHOW command. The SHOW SCHEMAS command is a synonym for SHOW DATABASES.
Syntax:
SHOW {DATABASES | SCHEMAS} [LIKE 'pattern' | WHERE expr];