MySQL Users and Privileges Quiz

This quiz tests your knowledge of MySQL users, privileges, and security best practices. It covers essential topics such as managing user accounts, assigning privileges, enforcing password policies, and securing access to your MySQL database. You’ll also encounter practical MySQL commands related to user creation, authentication, privilege management, and security enforcement. Use this quiz to assess your understanding of MySQL security and ensure you are following best practices for protecting your database.

Which MySQL table stores user access information?

mysql.users

mysql.credentials

mysql.user

mysql.access

None

Which MySQL privilege allows a user to create new databases?

GRANT DATABASE

CREATE DATABASE

NEW DATABASE

CREATE

None

What is the purpose of the FLUSH PRIVILEGES; command?

To delete unused database privileges

To reset all database passwords

To clear the MySQL error logs

To reload user privileges after modifications

None

How do you create a new MySQL user with a specific password?

ADD USER ‘john’@’localhost’ IDENTIFIED BY ‘password123’;

CREATE ACCOUNT ‘john’@’localhost’ SET PASSWORD ‘password123’;

NEW USER ‘john’@’localhost’ PASSWORD ‘password123’;

CREATE USER ‘john’@’localhost’ IDENTIFIED BY ‘password123’;

None

What SQL command retrieves a list of user accounts in MySQL?

SELECT username FROM mysql.accounts;

SELECT user FROM mysql.user;

SHOW USERS;

LIST USERS;

None

What command removes an existing MySQL user?

REMOVE USER ‘username’@’host’;

DELETE USER ‘username’@’host’;

REVOKE USER ‘username’@’host’;

DROP USER ‘username’@’host’;

None

How do you grant a user permission to perform SELECT operations on a specific database?

GIVE SELECT ON MyDB.* TO ‘user’@’localhost’;

GRANT SELECT ON MyDB.* TO ‘user’@’localhost’;

ALLOW SELECT ON MyDB.* TO ‘user’@’localhost’;

PERMIT SELECT ON MyDB.* TO ‘user’@’localhost’;

None

How can you rename a MySQL user?

UPDATE USER ‘olduser’@’host’ TO ‘newuser’@’host’;

RENAME USER ‘olduser’@’host’ TO ‘newuser’@’host’;

ALTER USER ‘olduser’@’host’ TO ‘newuser’@’host’;

CHANGE USER ‘olduser’@’host’ TO ‘newuser’@’host’;

None

What privilege allows a user to delete records from a table?

DROP

ALTER

DELETE

REMOVE

None

10.

What happens when you press the up arrow in MySQL after executing a CREATE USER command?

The MySQL client crashes

The command does not appear in history for security reasons

The command is executed again automatically

The command is stored in history and can be retrieved

None

11.

What wildcard character allows a user to connect from any host?

ALL

None

12.

What MySQL feature enforces strong password policies?

Password Checker

Security Enforcer

Validate Password Component

Password Manager

None

13.

How can you disable remote root access in MySQL?

REVOKE ALL PRIVILEGES FROM ‘root’@’%’;

DROP USER ‘root’@’%’;

UPDATE mysql.user SET Host=’localhost’ WHERE User=’root’;

DELETE FROM mysql.user WHERE User=’root’ AND Host NOT IN (‘localhost’, ‘127.0.0.1’, ‘::1’);

None

14.

What is the purpose of the REVOKE command?

To delete a database

To log out all active MySQL users

To remove previously granted privileges from a user

To reset all users’ passwords

None

15.

Which statement correctly changes a user's password in MySQL?

MODIFY PASSWORD FOR ‘john’@’localhost’ TO ‘newpassword’;

SET USER PASSWORD ‘john’@’localhost’ = ‘newpassword’;

UPDATE USER SET password=’newpassword’ WHERE user=’john’;

ALTER USER ‘john’@’localhost’ IDENTIFIED BY ‘newpassword’;

None

Enter your email address below if you would like to receive a copy of your quiz results.