[MySQL] ¿ø°Ý Á¢¼ÓÀÌ ¾ÈµÉ¶§ È®ÀÎÇÒ »çÇ×
* Linux ¹öÀü: Ubuntu 12.04.5 LTS Server
* ¿ìºÐÅõ Çѱ¹ Ä¿¹Â´ÏƼ: http://www.ubuntu-kr.org/
* Documentation: https://help.ubuntu.com/
< Ubuntu¿¡¼ MySQL ¼³Ä¡Çϱâ >
http://jacking.tistory.com/1116
< MySQL °Ë»ö >
sudo apt-cache search mysql-server
< MySQL ¼³Ä¡ >
sudo apt-get install mysql-server
=> 404 ¿¡·¯ ³²
Ubuntu Linux¿¡¼ MySQLÀ» ¼³Ä¡ÇÏ´Â °¡Àå ½¬¿î ¹æ¹ý
http://www.rackspace.com/knowledge_center/article/installing-mysql-server-on-ubuntu
Ubuntu package manager
sudo aptitude install mysql-server
root Password ¼³Á¤.
¼³Ä¡ ¿Ï·á.
¼³Ä¡µÈ ¹öÀü: Server version: 5.5.41-0ubuntu0.12.04.1 (Ubuntu)
< Booting ½Ã¿¡ ÀÚµ¿À¸·Î MySQL ½ÇÇàµÇµµ·Ï ¼³Á¤ >
sudo /usr/sbin/update-rc.d mysql defaults
¹æȺ®À» open ÇØ¾ß ¿ÜºÎ machine¿¡¼ mysql Server·Î Á¢±ÙÇÒ ¼ö ÀÖ´Ù.
iptables -I INPUT -p tcp --dport 3306 -m state --state NEW,ESTABLISHED -j ACCEPT
iptables -I OUTPUT -p tcp --sport 3306 -m state --state ESTABLISHED -j ACCEPT
< Ubuntu: Stat / Stop / Restart Iptables Firewall Service >
http://www.cyberciti.biz/faq/ubuntu-start-stop-iptables-service/
³ªÀÇ °æ¿ì´Â /etc/mysql/my.cnf ¿©±â¿¡ ÀÖ¾ú´Ù.
¿©±â¼
bind-address = 127.0.0.1
mysql> show variables like 'skip_networking';
< mysql service Àç½ÃÀÛ >
sudo service mysql restart
¿ÜºÎ¿¡¼ Á¢¼ÓÇÒ User ¸¸µé±â
CREATE USER 'testuser'@'localhost' IDENTIFIED BY 'Password';
CREATE USER 'testuser'@'%' IDENTIFIED BY 'Password';
# testuser User ¿¡°Ô testdb DB¿¡ ´ëÇÑ ¸ðµç ±ÇÇÑÀ» ºÎ¿©ÇÔ.
GRANT ALL PRIVILEGES ON testdb.* TO 'testuser'@'localhost' WITH GRANT OPTION;
# ¿ÜºÎ¿¡¼ Á¢¼ÓÇϱâ À§Çؼ 'testuser'@'%' User ¿¡ ´ëÇؼ ´Ù½Ã GRANT ÇØ ÁÜ.
GRANT ALL PRIVILEGES ON testdb.* TO 'testuser'@'%' WITH GRANT OPTION;
SHOW GRANTS FOR 'testuser';
mysql> select user, host, password from mysql.user;
+------------------+----------------------+-------------------------------------------+
| user | host | password |
+------------------+----------------------+-------------------------------------------+
| testuser | % | |
| testuser | localhost | *1122333445566778899012345678901234567890 |
+------------------+----------------------+-------------------------------------------+
+------------------+----------------------+-------------------------------------------+
| user | host | password |
+------------------+----------------------+-------------------------------------------+
| testuser | % | *1122333445566778899012345678901234567890 |
| testuser | localhost | *1122333445566778899012345678901234567890 |
+------------------+----------------------+-------------------------------------------+
À§ µÎ °æ¿ì´Â ERROR ¸Þ½ÃÁö°¡ ´Ù¸£´Ù.
À§ÀÇ °æ¿ì(¿¡·¯ ¸Þ½ÃÁö: ERROR 1130 (HY000))´Â Á¢±Ù ±ÇÇÑÀÌ ¾ø´Â °æ¿ì.
¾Æ·¡ °æ¿ì(¿¡·¯ ¸Þ½ÃÁö: ERROR 1045 (28000))´Â Password °¡ Ʋ¸° °æ¿ì.
¸î ½Ã°£ µ¿¾ÈÀÇ »ðÁúÀÇ °á·ÐÀº, ¿ø°ÝÀ¸·Î Á¢¼ÓÇϱâ À§Çؼ´Â HOST '%'¿¡ ´ëÇؼµµ »ç¿ëÀÚ¸¦ µû·Î »ý¼ºÇÏ°í, GRANT µµ µû·Î ÇØ ÁÖ°í ³ª¼ ´Ù½Ã password ¸¦ password() ÇÔ¼ö¸¦ ÀÌ¿ëÇؼ ´Ù½Ã update ÇØ ÁÖ¾î¾ß ÇÑ´Ù´Â Á¡ÀÌ´Ù.
±× ÈÄ¿¡,
mysql> flush privileges;
¸¦ ÇØ ÁÖ´øÁö ¾Æ´Ï¸é MySQL ¼¹ö¸¦ Àç±âµ¿ÇÒ °Í.
Ãâó: https://bryan7.tistory.com/428?category=509877 [¹Î¼³×Áý]