mysql_8_암호_복잡성_설정

차이

문서의 선택한 두 판 사이의 차이를 보여줍니다.

차이 보기로 링크

mysql_8_암호_복잡성_설정 [2020/02/18 12:50]
koov 만듦
mysql_8_암호_복잡성_설정 [2020/02/18 12:50] (현재)
koov [정책 변경]
줄 61: 줄 61:
 <code vim /​etc/​my.cnf>​ <code vim /​etc/​my.cnf>​
 [mysqld] [mysqld]
-# 
-# Remove leading # and set to the amount of RAM for the most important data 
-# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%. 
-# innodb_buffer_pool_size = 128M 
-# 
-# Remove the leading "# " to disable binary logging 
-# Binary logging captures changes between backups and is enabled by 
-# default. It's default setting is log_bin=binlog 
-# disable_log_bin 
-# 
-# Remove leading # to set options mainly useful for reporting servers. 
-# The server defaults are faster for transactions and fast SELECTs. 
-# Adjust sizes as needed, experiment to find the optimal values. 
-# join_buffer_size = 128M 
-# sort_buffer_size = 2M 
-# read_rnd_buffer_size = 2M 
-# 
-# Remove leading # to revert to previous value for default_authentication_plugin,​ 
-# this will increase compatibility with older clients. For background, see: 
-# https://​dev.mysql.com/​doc/​refman/​8.0/​en/​server-system-variables.html#​sysvar_default_authentication_plugin 
-# default-authentication-plugin=mysql_native_password 
-default-authentication-plugin=mysql_native_password 
- 
 datadir=/​var/​lib/​mysql datadir=/​var/​lib/​mysql
 socket=/​var/​lib/​mysql/​mysql.sock socket=/​var/​lib/​mysql/​mysql.sock
  • mysql_8_암호_복잡성_설정.txt
  • 마지막으로 수정됨: 2020/02/18 12:50
  • 저자 koov