2. # Copyright (c) 2017, Oracle and/or its affiliates. All rights reserved.
    3. #
    4. # This program is free software; you can redistribute it and/or modify
    5. # it under the terms of the GNU General Public License as published by
    6. # the Free Software Foundation; version 2 of the License.
    7. #
    8. # This program is distributed in the hope that it will be useful,
    9. # but WITHOUT ANY WARRANTY; without even the implied warranty of
    10. # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
    11. # GNU General Public License for more details.
    12. #
    13. # You should have received a copy of the GNU General Public License
    14. # along with this program; if not, write to the Free Software
    15. # Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA  02110-1301 USA
    17. #
    18. # The MySQL  Server configuration file.
    19. #
    20. # For explanations see
    21. # http://dev.mysql.com/doc/mysql/en/server-system-variables.html
    23. [mysql]
    25. #设置mysql客户端默认字符集
    26. default-character-set=utf8
    28. [mysqld]
    29. pid-file        = /var/run/mysqld/mysqld.pid
    30. socket          = /var/run/mysqld/mysqld.sock
    31. datadir         = /var/lib/mysql
    32. secure-file-priv= NULL
    33. # Disabling symbolic-links is recommended to prevent assorted security risks
    34. symbolic-links=0
    36. #服务端使用的字符集默认为8比特编码的latin1字符集
    37. character_set_server = utf8
    39. #创建新表时将使用的默认存储引擎
    40. default-storage-engine=INNODB
    42. #设置不区分大小写
    43. # 必须在安装好MySQL后 修改mySQL配置文件设置为不敏感，一旦启动后，再设置是无效的，而且启动报错；
    44. # 如果已经晚了，那必须把MySQL数据库文件全部 删除，修改配置文件再启动。
    45. lower_case_table_names=1