egov@egov-server:/$ sudo apt-get update
egov@egov-server:/$ sudo apt-get install mysql-server
egov@egov-server:/$ sudo ufw enable
egov@egov-server:/$ sudo ufw allow mysql
egov@egov-server:/$ sudo systemctl start mysql
egov@egov-server:/$ sudo systemctl enable mysql
egov@egov-server:/$ sudo /usr/bin/mysql -u root -p
CREATE SCHEMA EGOV_HOME;
USE EGOV_HOME;
egov_home
스키마 사용할 사용자 생성 (root는 접속이 불가능)mysql_native_password
)caching_sha2_password
)CREATE USER 'egov'@'%' IDENTIFIED WITH 'mysql_native_password' BY '1111';
CREATE USER 'egov'@'localhost' IDENTIFIED WITH 'mysql_native_password' BY '1111';
FLUSH PRIVILEGES;
DROP USER 'egov'@'localhost';
DROP USER 'egov'@'%';
egov_home
스키마 사용할 사용자에게 권한 부여GRANT ALL PRIVILEGES ON egov_home.* TO 'egov'@'%';
GRANT ALL PRIVILEGES ON egov_home.* TO 'egov'@'localhost';
FLUSH PRIVILEGES;
SHOW GRANTS FOR 'egov'@'localhost';
SELECT User, Host, authentication_string FROM mysql.user;
show variables like "%version%";
bind-address
, mysqlx-bind-address
값 변경egov@egov-server:/etc/mysql/mysql.conf.d$ cd /etc/mysql/mysql.conf.d
egov@egov-server:/etc/mysql/mysql.conf.d$ sudo vi mysqld.cnf
egov@egov-server:/etc/mysql/mysql.conf.d$ sudo systemctl restart mysql
egov@egov-server:/$ netstat -tnlp
egov@egov-server:/etc/mysql/mysql.conf.d$ cd /etc/mysql/mysql.conf.d
egov@egov-server:/etc/mysql/mysql.conf.d$ sudo vi mysqld.cnf
egov@egov-server:/etc/mysql/mysql.conf.d$ sudo systemctl restart mysql
egov@egov-server:/$ ps -ef | grep mysql
egov@egov-server:/$ netstat -ntap | grep LISTEN
egov@egov-server:/$ netstat -ntap | grep 3306
C:\Users\Ynjch\egovWorkspace01\sample\DATABASE
경로에서 아래 파일 확인all_sht_ddl_mysql.sql
all_sht_data_mysql.sql
egov_home
utf8
SELECT * FROM COMVNUSERMASTER;
sudo ufw status
결과, 등록이 안됐을 경우 Status: inactive
로 나옴egov@egov-server:/$ sudo ufw enable
egov@egov-server:/$ sudo ufw allow out 3306/tcp
egov@egov-server:/$ sudo ufw allow in 3306/tcp