1z0-908 Exam Dumps - MySQL 8.0 Database Administrator

ALTER USER 'joe'@'%' ACCOUNT LOCK

ALTER USER 'joe'@'%' SET password='*invalid*'

REVOKE ALL PRIVILEGES ON *.* FROM 'joe'@'%'

ALTER USER 'joe'@'%' PASSWORD HISTORY 0

ALTER USER 'joe'@'%' IDENTIFIED BY '*invalid*' PASSWORD EXPIRE

REVOKE USAGE ON *.* FROM 'joe'@'%'

It encrypts any connecting slaves connection thread.

It can be set at run time.

It requires a keyring plugin.

When enabled it encrypts existing binary logs.

It can be activated per session.

shell> cp /backup/customers.sdi /var/tmp

shell> cp /backup/customers.sdi /var/lib/mysql/shop/

mysql> SOURCE ‘/var/tmp/customers.sdi’

mysql> IMPORT TABLE FROM /var/tmp/customers.sdi

shell> cp /backup/customers.frm /var/lib/mysql/shop/

mysql> IMPORT TABLE FROM /var/lib/mysql/shop/customers.sdi

mysql> ALTER TABLE shop.customers IMPORT TABLESPACE

shell> mysql < audit_log_filter_linux_install.sql

shell> mysqld --initialize --log-raw=audit.log

mysql> INSTALL PLUGIN audit_log;

mysql> INSTALL COMPONENT audit_log;

Use the AES_ENCRYPT() MySQL function on the option file.

Use mysql_secure_installation to encrypt stored login credentials.

Use a text editor to create a new defaults file and encrypt it from Linux prompt.

Use mysql_config_editor to create an encrypted file.