vim /etc/mysql/mariadb.conf.d/50-server.cnf 에서 bind-address = 127.0.0.1 를 bind-address = 0.0.0.0 로 변경해야 외부에서 접속 가능한다. time-zone 변경 default-time-zone='+9:00' 수정한 다음, #>sudo systemctl enable mariadb.service #>sudo systemctl start mariadb.service 해서 반영된 점을 확인한다. #> cat /etc/mysql/mariadb.conf.d/50-server.cnf # # These groups are read by MariaDB server. # Use it for options that only the server (but not clients) should see # this is read by the standalone daemon and embedded servers [server] # this is only for the mysqld standalone daemon [mysqld] # # * Basic Settings # user = mysql pid-file = /run/mysqld/mysqld.pid basedir = /usr datadir = /var/lib/mysql tmpdir = /tmp lc-messages-dir = /usr/share/mysql lc-messages = en_US skip-external-locking # Broken reverse DNS slows down connections considerably and name resolve is # safe to skip if there