ÃֽŠ°Ô½Ã±Û(DB)
2019.02.11 / 13:13
MySQL DB»ý¼º, »ç¿ëÀÚÃß°¡, ±ÇÇѺο©
hanulbit
Ãßõ ¼ö 182
MySQLÀÇ DB»ý¼º, »ç¿ëÀÚÃß°¡ ±ÇÇѼ³Á¤ÇÏ´Â ºÎºÐ Æ÷½ºÆÃÇÏ°Ú½À´Ï´Ù.
MySQL DB »ý¼º |
MySQL Á¢¼Ó
1 2 | [root@web ~]# mysql -u root -p Enter password: |
Mysql DB utf-8 »ý¼º
1 2 | mysql> create database testDB default character set utf8; Query OK, 1 row affected (0.01 sec) |
ÇÑ±Û ±úÁüÀ» ¹æÁöÇϱâ À§ÇØ utf8·Î »ý¼ºÇÕ´Ï´Ù.
º¸Åë UTF-8·Î ¸¹ÀÌ ÇÏ´ÂÃß¼¼·Î UTF-8·Î »ý¼ºÇϽñ⠹ٶø´Ï´Ù.
MySQL »ç¿ëÀÚ Ãß°¡ |
»ç¿ëÀÚ °èÁ¤ ¼³Á¤
- create user »ç¿ëÇÒ°èÁ¤@'%' identified by '»ç¿ëÇÒ ºñ¹Ð¹øÈ£';
1 2 | mysql> create user test_DB@ '%' identified by '123456@' ; Query OK, 0 rows affected (0.00 sec) |
»ç¿ëÀÚ °èÁ¤¿¡ ¿ÜºÎ ±ÇÇÑÀ» ºÎ¿©ÇÏ·Á¸é, Host¸¦ '%'·Î ÇÏ¿© °èÁ¤À» Ãß°¡ÇÏ¸é µË´Ï´Ù.
MySQL »ç¿ëÀÚ ±ÇÇÑ ºÎ¿© |
MySQL DB, »ç¿ëÀÚ ±ÇÇÑ ºÎ¿©
»ç¿ë¹ý : grant all privileges on [DBÀ̸§].* to [°èÁ¤À̸§]@'¿ÜºÎÁ¢¼Ó ±ÇÇÑ' identified by '[Æнº¿öµå]';
1 | grant all privileges on test_DB.* to test_DB@ '%' identified by '123456@' ; |
À§¿Í °°ÀÌ ±ÇÇÑÀ» ƯÁ¤ DB ȤÀº °èÁ¤ÀÇ Á¢¼Ó ±ÇÇÑÀ» ¼³Á¤ÇÏ½Ã¸é µÇ¸ç '%' ÀÇ ±ÇÇÑÀ» ÁÖ½Ã¸é ¸ðµç ±ÇÇÑÀ» ÁÖ°Ô µË´Ï´Ù.