You have the following in your my.cnf configuration file:[mysqld]default_authentication_plugin=sha256_passwordYou want to create a new user who will be connecting from the IP address 192.0.2.10, and you want to use the authentication plug-in that implements SHA-256 hashing for user account passwords.Which two statements would create a user named webdesign for this IP address with the password of imbatman using a SHA_256 password hash? (Choose two.)
A MySQL database uses all InnoDB tables and is configured as follows;You will be setting up a replication slave by using mysqldump. You will need a consistent backup taken from your running production server. The process should have minimal impact to active database connections.Which two arguments will you pass to mysqldump to achieve this? (Choose two.)
The /myfolder/my.cnf file has option set:[mysqld]skip-log-bin/myfolder2/my.cnf has this option set:[mysqld]log-bin = /valid/path/to/mysqlbinlogAll mentioned paths are accessible to the account that you are currently using. Assume that any other options mentioned in either file are valid and legal option definitions.You start an instance by using this command line:mysqld --defaults-file=/myfolder/my.cnf --defaults-extra-file=/myfolder2/my.cnfWhat is the outcome?
You back up by using mysqldump.Which configuration is required on the MySQL Server to allow point-in-time recovery?
An existing master-slave setup is currently using a delayed replication of one hour. The master has crashed and the slave must be “rolled forward” to provide all the latest data.The SHOW SLAVE STATUS indicates these values:RELAY_LOG_FILE=hostname-relay-bin.00004RELAY_LOG_POS=1383 -Which command set would make the slave current?
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?
