A MySQL Server has been running an existing application successfully for six months. The my.cnf is adjusted to contain this additional configuration:

The MySQL Server is restarted without error.
What effect will the new configuration have on existing account?

• A.They all connect via the secure sha256_password algorithm without any configuration change.
• B.They are not affected by this configuration change.
• C.They will have their passwords updated on start-up to sha256_password format.
• D.They will have to change their password the next time they login to the server.

Comment: *

Name: *

Email: *

Verification: *

When you examine a new MySQL installation with default configuration, you find a file called ibdata1 in the database directory. Which two statements are true about this file?

• 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.

Comment: *

Name: *

Email: *

Verification: *

An administrator installs MySQL to run under a mysql OS account. The administrator decides to disable logins to the mysql account by using /nologin or /bin/false as the user's shell setting.
Which statement is true?

• A.This prevents mysqld from starting when standard startup scripts are used.
• B.This prevents creation of a command shell with the mysql account, while allowing mysqld to run.
• C.The mysql user needs a login and its home directory must be the base directory of the installation.
• D.The OS needs to allow logging in as mysql so that administrative tasks can be performed.

Comment: *

Name: *

Email: *

Verification: *

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?

• A.executing REVOKE FILE FROM *.*
• B.setting the --local-service=0 option when starting mysqld
• C.setting the --open-files-limit=0 option when starting mysqld
• D.setting the --local-infile=0 option when starting mysqld
• E.executing REVOKE FILE ON *.* FROM ' ' @'%'
• F.executing REVOKE LOAD FROM *.*

Comment: *

Name: *

Email: *

Verification: *

Assuming that a user has correct privileges, which Linux console command will fail to shut down a MySQL server?

• A.mysqld -e 'shutdown'
• B.mysql -e 'shutdown'
• C.service mysqld stop
• D.mysqladmin shutdown

Comment: *

Name: *

Email: *

Verification: *