You have installed the validate_password plug-in and set the validate_password_policy variable.
Which validation is affected by the validate_password_policy setting?
Examine the mysqldumpslow output:
Which two options could explain the slow query?
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?
You have been tasked with creating a QA MySQL instance on a DB host, which already has one large instance in /var/lib/mysql/running as the mysqluser. The MySQL configuration file for the existing instance includes:
The default instance was installed using the OS package manager. The latest binaries for both client and server are already in ENV PATH.
The new instance will run as a different user from the existing instance for security purposes.
You create the new data directory successfully and move on to initialize the new DATADIR.
You verify the output to confirm the operation's success:
[mysqlQA@linux /var/lib/]$ mysqld --initialize --datadir=/var/lib/mysql_QA 2>&1 | tail -n3
2018-05-03T12:16:10.928809Z 0 [ERROR] Could not open file '/var/log/mysqld.log' for error logging:
Permission denied
2018-05-03T12:16:10.928841Z 0 [ERROR] Aborting
[mysqlQA@linux /var/lib/]$
The initialization of the instance has failed.
What would you do to enable the initialization to succeed?
An employee cannot access the company database. You check the connection variables:
A look at the user privileges shows:
What is a valid explanation for why one of the users is unable to connect to the database?
