mysql my.cnf 配置

最新推荐文章于 2024-10-13 22:06:23 发布

原创最新推荐文章于 2024-10-13 22:06:23 发布 · 789 阅读

0 ·

CC 4.0 BY-SA版权

mysql 专栏收录该内容

15 篇文章

订阅专栏

本文详细解析了MySQL配置文件的各项参数设置，包括字符集、日志路径、数据目录等关键配置项，帮助读者理解如何针对不同需求调整MySQL服务器配置。

 1 [mysqld]
      2 collation-server = utf8_unicode_ci
      3 character-set-server = utf8
      4 datadir=/var/lib/mysql
      5 socket=/var/lib/mysql/mysql.sock
      6 log-bin=mysql-bin
      7 server-id=1
      8 user=mysql
      9 # Default to using old password format for compatibility with mysql 3.x
     10 # clients (those using the mysqlclient10 compatibility package).
     11 old_passwords=1
     12 # default-character-set=utf8
     13 init_connect='SET NAMES utf8'
     14
     15 # Disabling symbolic-links is recommended to prevent assorted security risks;
     16 # to do so, uncomment this line:
     17 # symbolic-links=0
     18
     19 [mysqld_safe]
     20 log-error=/var/log/mysqld.log
     21 pid-file=/var/run/mysqld/mysqld.pid
     22
     23 [client]
     24 default-character-set=utf8
     25
     26 [mysql]
     27 default-character-set=utf8