记ubuntu系统下的MySQL服务端配置文件

        近日在服务器ubuntu系统上配置MySQL，在此记录MySQL服务端配置文件mysqld.cnf。

1.服务端配置文件默认位置

        /etc/mysql/mysql.conf.d/mysqld.cnf

2.服务端配置文件详情

        mysqld.cnf：

# Copyright (c) 2014, 2021, Oracle and/or its affiliates.
#
# This program is free software; you can redistribute it and/or modify
# it under the terms of the GNU General Public License, version 2.0,
# as published by the Free Software Foundation.
#
# This program is also distributed with certain software (including
# but not limited to OpenSSL) that is licensed under separate terms,
# as designated in a particular file or component or in included license
# documentation.  The authors of MySQL hereby grant you an additional
# permission to link the program and your derivative works with the
# separately licensed software that they have included with MySQL.
#
# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
# GNU General Public License, version 2.0, for more details.
#
# You should have received a copy of the GNU General Public License
# along with this program; if not, write to the Free Software
# Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA  02110-1301 USA

#
# The MySQL  Server configuration file.
#
# For explanations see
# http://dev.mysql.com/doc/mysql/en/server-system-variables.html

[mysqld]
pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock
datadir         = /var/lib/mysql
log-error       = /var/log/mysql/error.log
#skip-grant-tables
# By default we only accept connections from localhost
bind-address    = 0.0.0.0
#bind-address            = 127.0.0.1
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

上图中 bind-address = 0.0.0.0表示任意主机都可远程访问MySQL，bind-address = 127.0.0.1表示只有本机才可访问MySQL；skip-grant-tables表示跳过数据权限验证。