mysqld.cnf 1.7 KB

1234567891011121314151617181920212223242526272829303132333435363738
  1. # Copyright (c) 2014, 2016, Oracle and/or its affiliates. All rights reserved.
  2. #
  3. # This program is free software; you can redistribute it and/or modify
  4. # it under the terms of the GNU General Public License, version 2.0,
  5. # as published by the Free Software Foundation.
  6. #
  7. # This program is also distributed with certain software (including
  8. # but not limited to OpenSSL) that is licensed under separate terms,
  9. # as designated in a particular file or component or in included license
  10. # documentation. The authors of MySQL hereby grant you an additional
  11. # permission to link the program and your derivative works with the
  12. # separately licensed software that they have included with MySQL.
  13. #
  14. # This program is distributed in the hope that it will be useful,
  15. # but WITHOUT ANY WARRANTY; without even the implied warranty of
  16. # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
  17. # GNU General Public License, version 2.0, for more details.
  18. #
  19. # You should have received a copy of the GNU General Public License
  20. # along with this program; if not, write to the Free Software
  21. # Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA
  22. #
  23. # The MySQL Server configuration file.
  24. #
  25. # For explanations see
  26. # http://dev.mysql.com/doc/mysql/en/server-system-variables.html
  27. [mysqld]
  28. pid-file = /var/run/mysqld/mysqld.pid
  29. socket = /var/run/mysqld/mysqld.sock
  30. datadir = /var/lib/mysql
  31. #log-error = /var/log/mysql/error.log
  32. # By default we only accept connections from localhost
  33. #bind-address = 127.0.0.1
  34. # Disabling symbolic-links is recommended to prevent assorted security risks
  35. symbolic-links=0
  36. sql_mode = STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION