MySQL Account Authentication and Roles

Submit

2. True or False: You can grant privileges to a role before assigning it to users.

True

False

3. Which privilege allows viewing table structure but not accessing data?

SHOW

DESCRIBE

REFERENCES

USAGE

Submit

5. Which privilege allows a user to execute stored procedures?

EXECUTE

PROCEDURE

CALL

FUNCTION

6. True or False: The root user always has the password 'root' by default.

True

False

Submit

8. What does the GRANT OPTION privilege allow a user to do?

Grant their own privileges to other users

Choose which privileges to use

Modify grant tables directly

Create new privilege levels

9. Which column in mysql.user stores the hashed password?

Password

Authentication_string

Password_hash

Encrypted_password

10. True or False: The wildcard '%' in hostname matches any character except the dot.

True

False

11. Which statement creates a new MySQL user account?

CREATE USER 'username'@'host' IDENTIFIED BY 'password';

NEW USER 'username'@'host' WITH PASSWORD 'password';

ADD USER 'username'@'host' USING 'password';

REGISTER USER 'username'@'host' IDENTIFIED AS 'password';

12. Which privilege is required to create a role in MySQL 8.0+?

CREATE ROLE privilege

SUPER privilege

ADMIN privilege

Both SUPER and ADMIN privileges

13. What does the FLUSH PRIVILEGES statement do?

Deletes all user accounts

Reloads grant tables from disk

Resets all user passwords

Removes all privileges from all users

14. True or False: A user with 'user'@'%' can connect from any host.

True

False

15. Which table stores user account information in MySQL?

Mysql.users

Mysql.accounts

Mysql.user

Mysql.authentication

16. What is the primary purpose of the SUPER privilege?

Perform administrative operations like FLUSH and SHUTDOWN

Create and drop databases

Grant privileges to other users

Execute stored procedures

17. Which statement revokes a specific privilege from a user?

REMOVE GRANT SELECT ON db.* FROM 'user'@'host';

REVOKE SELECT ON db.* FROM 'user'@'host';

DELETE GRANT SELECT ON db.* FROM 'user'@'host';

REVOKE PERMISSION SELECT ON db.* FROM 'user'@'host';

18. What is the correct syntax to grant all privileges on a database to a user?

GRANT ALL ON database.* TO 'user'@'host';

GRANT FULL ON database.* TO 'user'@'host';

GRANT ALL PRIVILEGES database.* FOR 'user'@'host';

GRANT EVERYTHING ON database.* TO 'user'@'host';

19. Which privilege allows a user to modify table structures?

ALTER

MODIFY

STRUCTURE

SCHEMA

20. What does the host part of 'user'@'host' control?

The database name the user can access

The IP address or hostname from which the user can connect

The password expiration date

The user's privilege level globally

MySQL DBA Account Authentication and Roles Quiz

1. The correct syntax to change a user's password is ____.

2.

What first name or nickname would you like us to use?

2. True or False: You can grant privileges to a role before assigning it to users.

3. Which privilege allows viewing table structure but not accessing data?

4. The statement to drop a user account is DROP USER ____.

5. Which privilege allows a user to execute stored procedures?

6. True or False: The root user always has the password 'root' by default.

7. To assign a role to a user in MySQL 8.0+, use the ____ statement.

8. What does the GRANT OPTION privilege allow a user to do?

9. Which column in mysql.user stores the hashed password?

10. True or False: The wildcard '%' in hostname matches any character except the dot.

11. Which statement creates a new MySQL user account?

12. Which privilege is required to create a role in MySQL 8.0+?

13. What does the FLUSH PRIVILEGES statement do?

14. True or False: A user with 'user'@'%' can connect from any host.

15. Which table stores user account information in MySQL?

16. What is the primary purpose of the SUPER privilege?

17. Which statement revokes a specific privilege from a user?

18. What is the correct syntax to grant all privileges on a database to a user?

19. Which privilege allows a user to modify table structures?

20. What does the host part of 'user'@'host' control?