Mysql 설치
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 |
sudo apt install mysql-server -y #보안 설정 sudo mysql_secure_installation # YES NO VALIDATE PASSWORD → N Remove anonymous users → Y Disallow root login remotely → Y Remove test database → Y Reload privilege tables → Y # 접속 sudo mysql |
계정 생성
|
1 2 3 4 5 |
CREATE USER 'admin01'@'%' IDENTIFIED BY '11119999'; GRANT ALL PRIVILEGES ON *.* TO 'admin01'@'%'; FLUSH PRIVILEG |
mysql conf
|
1 2 3 4 5 6 7 8 |
sudo vi /etc/mysql/mysql.conf.d/mysqld.conf # 주석처리 #bind-address = 127.0.0.1 #mysqlx-bind-address = 127.0.0.1 |
mysql 재시작 / 방화벽 오픈
|
1 2 3 4 5 |
sudo systemctl restart mysql sudo ufw allow mysql |