[Linux] MariaDB 포트 변경

mariaDB 포트 변경

 

0. 서버 접속 후 다음 명령 실행

 

[root@inno_tech ~]# vi /etc/my.cnf.d/server.cnf

 

1. 다음 설정 파일에서 [mysql] 섹션 바로 아래에 port 변경

 

#
# These groups are read by MariaDB server.
# Use it for options that only the server (but not clients) should see
#
# See the examples of server my.cnf files in /usr/share/mysql/
#

# this is read by the standalone daemon and embedded servers
[server]

# this is only for the mysqld standalone daemon
[mysqld]
port=23306
init-connect="SET collation_connection=utf-general_ci"
init-connect="SET NAMES utf8"
character-set-server=utf8
collation-server=utf8_unicode_ci
#
# * Galera-related settings
#
[galera]
# Mandatory settings
#wsrep_on=ON
#wsrep_provider=
#wsrep_cluster_address=
#binlog_format=row
#default_storage_engine=InnoDB
#innodb_autoinc_lock_mode=2
#
# Allow server to accept connections on all interfaces.
#
bind-address=0.0.0.0
#
# Optional setting
#wsrep_slave_threads=1
#innodb_flush_log_at_trx_commit=0

# this is only for embedded server
[embedded]

# This group is only read by MariaDB servers, not by MySQL.

 

2. 포트번호 변경 후 저장하고 mariadb 재기동

 

[root@inno_tech ~]# systemctl restart mariadb

 

 

만약 방화벽 정책에 변경한 포트가 허용되지 않았다면 허용해주면 된다.