You have installed MySQL Server for the first time on your system. However, the data directory along with the tables in the mysql system database are missing. Which step do you perform to create the contents of the data directory?
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? (Choose two.)
Which are three facts about backups with mysqldump? (Choose three.)
Consider the key buffer in a MySQL server.Which two statements are true about this feature? (Choose two.)
You will configure a MySQL Server to act as a replication master. Which two options must be configured correctly to allow this? (Choose two.)
You have just executed a manual backup by using this command: mysqlbackup –u root –p –-socket=/tmp/my.sock –-backup-dir=/my/backup/ backupThe operation completed without error.What is the state of this backup and operation required before it is ready to be restored?
