네이버 클라우드 MYSQL 3306 포트 외부 접속
root@ask-server:/etc/mysql# netstat -antp | grep mysql
tcp 0 0 127.0.0.1:3306 0.0.0.0:* LISTEN 1266/mysqld
root@ask-server:/etc/mysql# cd /etc/mysql
root@ask-server:/etc/mysql# ls
conf.d my.cnf my.cnf.fallback mysql.cnf mysql.conf.d
root@ask-server:/etc/mysql# cat ./my.cnf | grep address
root@ask-server:/etc/mysql# cat ./my.cnf
# Copyright (c) 2016, Oracle and/or its affiliates. All rights reserved.
#
# This program is free software; you can redistribute it and/or modify
# it under the terms of the GNU General Public License as published by
# the Free Software Foundation; version 2 of the License.
#
# 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 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
!includedir /etc/mysql/conf.d/
!includedir /etc/mysql/mysql.conf.d/
# Recommended in nCloud for MySQL 5.7 Basic setup
[mysqld]
innodb_file_per_table
innodb_log_file_size = 512M
innodb_log_files_in_group = 2
default_storage_engine=InnoDB
query_cache_type = ON
query_cache_size = 0M
expire_logs_days = 7
sysdate-is-now
log_timestamps = SYSTEM
slow_query_log
root@ask-server:/etc/mysql# cd mysql.con*
root@ask-server:/etc/mysql/mysql.conf.d# ll
total 12
drwxr-xr-x 2 root root 4096 Feb 7 2017 ./
drwxr-xr-x 4 root root 4096 Feb 7 2017 ../
-rw-r--r-- 1 root root 1189 Nov 28 2016 mysqld.cnf
root@ask-server:/etc/mysql/mysql.conf.d# cat mysqld.cnf | grep address
bind-address = 127.0.0.1
root@ask-server:/etc/mysql/mysql.conf.d#
root@ask-server:/etc/mysql/mysql.conf.d# vi mysqld.cnf
root@ask-server:/etc/mysql/mysql.conf.d# cat mysqld.cnf | grep address
#bind-address = 127.0.0.1
root@ask-server:/etc/mysql/mysql.conf.d#
root@ask-server:/etc/mysql/mysql.conf.d#
root@ask-server:/etc/mysql/mysql.conf.d# service mysql restart
root@ask-server:/etc/mysql/mysql.conf.d# netstat -antp | grep mysql
tcp6 0 0 :::3306 :::* LISTEN 20616/mysqld
