A.The mysqluser needs a login and its home directory must be the base directory of the installation.

B.The OS needs to allow logging in as mysqlso that administrative tasks can be performed.

C.This prevents mysqldfrom starting when standard startup scripts are used.

D.This prevents creation of a command shell with the mysqlaccount, while allowing mysqldto run.

A.Start the MySQL Server in --safe-mode, which only loads the privilege system for changes as data is inaccessible.

B.Start the MySQL Server with reset-root-password in my.cnf, which will prompt you to enter a new root user password.

C.Start the MySQL Server with --init-filepointing to SQL that executes an ALTER USER statement to change the root user password.

D.Start the MySQL Server with --skip-grant-tables and execute SQL, which will update the root password.

E.Start the MySQL Server with -initialize-insecureto force a password reset procedure on the command line.

A.to prevent any transaction experiencing a deadlock

B.to allow for point-in-time recovery on the slave

C.to prevent schema changes from propagating to the slave before they are validated

D.to allow a backup to be created under reduced load

E.to allow the remaining events to be processed on the slave while not receiving new events from the master

A.it contains the binary log.

B.it contains a general tablespace.

C.it is the default location for all new tables that you create.

D.it contains the system tablespace.

E.it contains the redo log.

F.it contains the undo log.

A.The dictionary file is an insecure location.

B.The validate_password plug-in has not been loaded.

C.The dictionary file word list is too short.

D.The name of the dictionary file is too obvious.

E.validate_password_policy cannot be set without restarting the MySQL instance.

F.validate_password_dictionary_file cannot be set without restarting the MySQL instance.