You want to immediately stop access to a database server for remote user 'mike'@'client.example.com'. This user is currently not connected to the server.
Which two actions can you take to stop any access from the user?

To satisfy a security requirement, you have created or altered some user accounts to include REQUIRE X509.
Which additional task needs to be performed for those user accounts to fulfill the requirement to use X509?

Examine the mysqldumpslow output:

Which two options could explain the slow query? (Choose two.)

Due to an authentication plug-in that is used on the server, passwords are required to be sent as clear text as opposed to the usual encrypted format.
Which two methods would allow the mysql client to connect to the server and send clear text passwords?

You have installed MySQL Server for the first time on your system. However, the data directory along with the tables in the mysqlsystem database are missing. Which step do you perform to create the contents of the data directory?