These details are shown when logged in to an account:Which set of statements would match the accounts shown?
Host slave1 has ip address 192.0.2.10.Host slave2 has ip address 203.0.113.50Examine these commands:Why did this error occur?
You are setting up a new installation of MySQL Server 5.7 (a GA release.) You have used a ZIP or TAR package to ensure that the mysqld binary, along with its support files, such as plug-ins and error messages, now exist on the host. Assume that the default datadir exists on the host. You installed the binary in the default location (the default --basedir value) for your operating system.Which step should you perform before defining your own databases and database tables?
Consider that local disk files are accessible via MySQL with commands such as: mysql> LOAD DATA LOCAL INFILE ‘/etc/passwd’ INTO TABLE mypasswords;What change could be made to stop any breach via this insecurity?
An admin attempts to enforce stronger security by using these commands:The admin then leaves the system running with the specified changes. What are two remaining security concerns? (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?
