Question 81

After rebooting the host, you attempt to start the mysqld service. You get the following error:
Can't start the server: Bind on TCP/IP port: Address already in use
What is the most likely cause of this error?
  • Question 82

    There are multiple instances of MySQL Server running on a single OS that is backed up using the mysqlbackup command.
    The /etc/my/cnf contains default values, for example, datadir=/var/lib/mysql/, with extra instances having their own separate my.cnf file (for example /etc/mysql/instanceN.cnf) overriding the defaults. A restore of the second instance is attempted from the mysqlbackup archive using this command:
    mysqlbackup --backup-dir=/opt/backup/mysql/instance2 copy-back
    Upon starting the second MySQL instance, you notice that the data does not match the expected backup.
    Which command-line option is required to successfully update the second instance?
  • Question 83

    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?
  • Question 84

    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.)
  • Question 85

    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 --basedirvalue) for your operating system.
    Which step should you perform before defining your own databases and database tables?