1Z0-888 Exam Question 31

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?
  • 1Z0-888 Exam Question 32

    You attempt to connect to a MySQL Server by using the mysql client program. However, you receive this notice:

    What would you run to fix the issue?
  • 1Z0-888 Exam Question 33

    You have a MySQL instance with the following variables in the /etc/my.cnf file:

    You issue these statements:
    USE prices;
    UPDATE sales.january SET amount=amount+1000;
    An hour after excluding the statements, you realize that you made a mistake and you want to go to the binary log and look at the statements again.
    Which statement is true? (Choose two.)
  • 1Z0-888 Exam Question 34

    You will configure a MySQL Server to act as a replication master. Which two options must be configured correctly to allow this?
  • 1Z0-888 Exam Question 35

    An employee cannot access the company database. You check the connection variables:

    A look at the user privileges shows:

    What is a valid for why one of the users is unable to connect to the database?