You have just created a replication slave from a backup of the master made with mysqldump:
You try to log in to the slave with the application user, but fail as follows:
The login works on the master.
Which two changes to the process can fix the issue?
Which storage option for MySQL data directory typically offers the worst performance in a highly concurrent, OLTP-heavy, IO-bound workload?
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?
While attempting to set up a new replication slave on host '192.168.0.25' with the user 'replication', you encounter this error:
What should you do to resolve this error?
You have created a backup of the 'sales' database with the command:
Which two procedures can be used to restore the 'orders' table from the backup?
Submit Cancel