mysql_8_기본설정사항 [AllThatLinux!]

mysql_8_기본설정사항

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

차이 보기로 링크

--- mysql_8_기본설정사항 [2023/09/21 05:15] – [Database Initialize] koov
+++ mysql_8_기본설정사항 [2025/04/17 01:23] (현재) – koov
@@ 줄 1: / 줄 1: @@
 ====== MySQL 8 기본 설정사항 ======
   * ''/app/mysql'' 경로에 zip 방식으로 설치한 경우
   * DATA경로는 ''/app/mysql_data'' 라고 가정
+===== zip 파일 수동 설치 =====
+  * ''mysql server'' 수동설치시 ''mysql client'' 는 기본 OS패키지에서 설치하는것을 권장한다.
+  * ''mysql'' user 생성해야함 - ''uid=27(mysql) gid=27(mysql) groups=27(mysql)''
+''mysql-8.0.42-1'' 기본 ''my.cnf''
+<WRAP prewrap>
+<code vim>
+# For advice on how to change settings please see
+# http://dev.mysql.com/doc/refman/8.0/en/server-configuration-defaults.html
+[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
+datadir=/var/lib/mysql
+socket=/var/lib/mysql/mysql.sock
+log-error=/var/log/mysqld.log
+pid-file=/var/run/mysqld/mysqld.pid
+</code>
+</WRAP>
 ===== my.cnf =====

mysql_8_기본설정사항.1695273355.txt.gz
마지막으로 수정됨: 2023/09/21 05:15
저자 koov