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.

What MySQL feature enforces strong password policies?

Security Enforcer

Password Manager

Password Checker

Validate Password Component

None

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

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

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

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

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

None

What is the purpose of the FLUSH PRIVILEGES; command?

To clear the MySQL error logs

To delete unused database privileges

To reset all database passwords

To reload user privileges after modifications

None

Which MySQL table stores user access information?

mysql.user

mysql.access

mysql.credentials

mysql.users

None

What command removes an existing MySQL user?

DELETE USER ‘username’@’host’;

DROP USER ‘username’@’host’;

REMOVE USER ‘username’@’host’;

REVOKE USER ‘username’@’host’;

None

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

ALL

None

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

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

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

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

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

None

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

The command is stored in history and can be retrieved

The command is executed again automatically

The command does not appear in history for security reasons

The MySQL client crashes

None

Which MySQL privilege allows a user to create new databases?

CREATE

CREATE DATABASE

GRANT DATABASE

NEW DATABASE

None

10.

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

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

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

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

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

None

11.

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

DROP

REMOVE

DELETE

ALTER

None

12.

What is the purpose of the REVOKE command?

To delete a database

To remove previously granted privileges from a user

To log out all active MySQL users

To reset all users’ passwords

None

13.

How can you disable remote root access in MySQL?

DROP USER ‘root’@’%’;

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

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

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

None

14.

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

SELECT user FROM mysql.user;

SELECT username FROM mysql.accounts;

SHOW USERS;

LIST USERS;

None

15.

How can you rename a MySQL user?

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

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

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

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

None

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