MySQL Account Authentication and Roles

1. 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

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

True

False

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

True

False

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

True

False

5. 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

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

True

False

7. 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';

8. 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';

9. Which table stores user account information in MySQL?

Mysql.users

Mysql.accounts

Mysql.user

Mysql.authentication

10. 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

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

CREATE ROLE privilege

SUPER privilege

ADMIN privilege

Both SUPER and ADMIN privileges

12. 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';

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

Password

Authentication_string

Password_hash

Encrypted_password

14. 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

Submit

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

ALTER

MODIFY

STRUCTURE

SCHEMA

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

EXECUTE

PROCEDURE

CALL

FUNCTION

Submit

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

SHOW

DESCRIBE

REFERENCES

USAGE

Submit

MySQL DBA Account Authentication and Roles Quiz

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

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. True or False: The root user always has the password 'root' by default.

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

5. What does the FLUSH PRIVILEGES statement do?

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

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

8. Which statement creates a new MySQL user account?

9. Which table stores user account information in MySQL?

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

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

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

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

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

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

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

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

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

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

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