MySQL Secure Deployment Guide  /  Deployment Configuration File

Appendix C Deployment Configuration File

Upon the completion of the deployment described in this guide, the MySQL configuration file (/etc/my.cnf) contains these configuration settings:

[mysqld]
datadir=/usr/local/mysql/data
socket=/tmp/mysql.sock
port=3306
log-error=/usr/local/mysql/data/localhost.localdomain.err
user=mysql
secure_file_priv=/usr/local/mysql/mysql-files
local_infile=OFF
plugin-load-add=validate_password.so
validate-password=FORCE_PLUS_PERMANENT
validate_password_policy=MEDIUM
validate_password_check_user_name=1
audit-log=FORCE_PLUS_PERMANENT
query_cache_type=0
query_cache_size=0
mysql_firewall_mode=ON
plugin-load-add=connection_control.so
connection-control=FORCE_PLUS_PERMANENT
connection-control-failed-login-attempts=FORCE_PLUS_PERMANENT
connection_control_failed_connections_threshold=3
connection_control_min_connection_delay=1000
connection_control_max_connection_delay=2147483647
block_encryption_mode=aes-256-cbc
plugin-load-add=auth_socket.so
auth_socket=FORCE_PLUS_PERMANENT
ssl_ca=ca.pem
ssl_cert=client-cert.pem
ssl_key=client-key.pem
bind_address=192.0.2.24
tls_version=TLSv1.2
ssl_cipher=DHE-RSA-AES128-GCM-SHA256
default_password_lifetime=120

PREV   HOME   UP  
User Comments
User comments in this section are, as the name implies, provided by MySQL users. The MySQL documentation team is not responsible for, nor do they endorse, any of the information provided here.
Sign Up Login You must be logged in to post a comment.