MySQL ๋ฆฌ๋ชจํธ์์ Access ๊ฐ๋ฅํ๊ฒ ์ค์ ํ๋ ๋ฒ
- vi /etc/my.cnf
[mysqld] ํญ๋ชฉ์ ๋ค์ ๋ด์ฉ ์ถ๊ฐ
ํญ๋ชฉ ์ถ๊ฐ## MySQL ์๋ฒ์ ip ์ถ๊ฐ ## ex. 192.168.0.7 ์ผ ๊ฒฝ์ฐ bind-address=192.168.0.7
- MySQ ์ฌ๊ตฌ๋
Connect to mysql server as root
mysql -u root -p mysql
DB ๋ฐ ๊ณ์ ์์ฑ/์๊ฒฉ ๊ถํ ์ถ๊ฐ (์์ ๊ฒฝ์ฐ)
MySQL ์ ์ฐ๊ฒฐํ๋ ค๋ client ip๋ 192.168.0.8๋ผ ๊ฐ์
CREATE DATABASE lesstifdb CHARACTER SET utf8 COLLATE utf8_bin;
GRANT ๋ก ๊ถํ ๋ถ์ฌ
๋จ์ผ Host ์ง์ GRANT ALL ON lesstif.* to 'lesstifdb '@'127.0.0.1' IDENTIFIED BY 'secret'; GRANT ALL ON lesstif.* to 'lesstifdb '@'localhost' IDENTIFIED BY 'secret'; GRANT ALL ON lesstif.* to 'lesstifdb '@'192.168.0.8' IDENTIFIED BY 'secret'; flush privileges;
Host ๋์ญ ์ง์ GRANT ALL ON lesstif.* to 'lesstifdb '@'127.0.0.1' IDENTIFIED BY 'secret'; GRANT ALL ON lesstif.* to 'lesstifdb '@'localhost' IDENTIFIED BY 'secret'; GRANT ALL ON lesstif.* to 'lesstifdb '@'192.168.0.%' IDENTIFIED BY 'secret'; flush privileges;
- 3306 ํฌํธ๋ฅผ ๋ฐฉํ๋ฒฝ์์ ์ด๊ณ ์ฐ๊ฒฐํ๋ ค๋ client ์์ ์ฐ๊ฒฐ ํ์ธ
๊ฐ์ด ๋ณด๊ธฐ
- putty ๋ก ssh port forwarding ํ์ฌ remote ์ ์๋ MySQL ์ฐ๊ฒฐ
- MySQL ๋ฐ์ดํ๋ฒ ์ด์ค์ ์ฌ์ฉ์ ๊ณ์ ์์ฑํ๊ธฐ