ÃֽŠ°Ô½Ã±Û(DB)
2019.02.11 / 13:19

MySQL ¼³Ä¡ÈÄ Á¢¼ÓÀº µÇ´Âµ¥ DB°¡ ¾ø´Ù°í ÇÕ´Ï´Ù.ERROR 1049 (42000) : ¾Ë ¼ö¾ø´Â µ¥ÀÌÅͺ£À̽º

hanulbit
Ãßõ ¼ö 216

´Â ³» Æ©Å丮¾ó µ¥ÀÌÅͺ£À̽º °³¹ß ȯ°æ¿¡ ·Î±×ÀÎ ÇÒ ¼ö¾ø´Â °Í :

Ayman$ mysql -u blog -p blog_development 
Enter password: 
ERROR 1049 (42000): Unknown database 'blog_development' 

³ª´Â blog_development ºÎºÐÀ» Á¦¿ÜÇÏ°í µ¥ÀÌÅͺ£À̽º ¹ú±Ý¿¡ ·Î±×ÀÎ ÇÒ ¼ö ÀÖ½À´Ï´Ù :

Ayman$ mysql -u blog -p 
Enter password: 
Welcome to the MySQL monitor. Commands end with ; or \g. 
Your MySQL connection id is 1858 

³»°¡ ¸ðµç ¾×¼¼½º ºÎ¿©·ÎÁÖ´Â ¹«½¼ È®½ÇÇÏÁö :

mysql> GRANT ALL PRIVILEGES ON blog_development.* 
    -> TO 'blog'@'localhost' 
    -> IDENTIFIED BY 'newpassword'; 
Query OK, 0 rows affected (0.01 sec) 

mysql> SHOW GRANTS FOR 'blog'@'localhost' 
    -> ; 
+----------------------------------------------------------------------------------------- --------------------+ 
| Grants for blog@localhost                      | 
+----------------------------------------------------------------------------------------- --------------------+ 
| GRANT USAGE ON *.* TO 'blog'@'localhost' IDENTIFIED BY PASSWORD '*FE4F2D624C07AAEBB979DA5C980D0250C37D8F63' | 
| GRANT ALL PRIVILEGES ON `blog`.* TO 'blog'@'localhost'              | 
| GRANT ALL PRIVILEGES ON `blog_development`.* TO 'blog'@'localhost'           | 
+----------------------------------------------------------------------------------------- --------------------+ 
3 rows in set (0.00 sec) 

´©±¸´Â ¹«¾ùÀ» ½ÃµµÇÏ´Â ´Ü¼­¸¦ °¡Áö°í ÀÖ½À´Ï±î? °¨»ç! ¶ÇÇÑ, Ãø¸é ³ëÆ® - ±×°ÍÀº ÀÌ»óÇÑ ³»°¡ °¡Áø ¿©·¯ ·çÆ® »ç¿ëÀÚ?

mysql> select User from mysql.user; 
+------+ 
| User | 
+------+ 
| root | 
| root | 
|  | 
| root | 
|  | 
| blog | 
| root | 
+------+ 
7 rows in set (0.00 sec) 

ÆíÁýÀÌ : ³ª´Â MySQLÀÇ¿¡ CREATE DATABASE ¸í·ÉÀ» »ç¿ëÇÏ¿© µ¥ÀÌÅͺ£À̽º ºí·Î±×¸¦ ¸¸µé¾î asking- »ç¶÷µéÀ» À§ÇØ. ¿©±â ³» È°¼º µ¥ÀÌÅͺ£À̽º´Â ´ÙÀ½°ú °°½À´Ï´Ù

mysql> SHOW DATABASES; 
+--------------------+ 
| Database   | 
+--------------------+ 
| information_schema | 
| blog    | 
| mysql    | 
| performance_schema | 
| test    | 
+--------------------+ 
5 rows in set (0.00 sec) 



blog_developmentÀÌ

Á¸ÀçÇÏÁö ¾Ê´Â ´ç½ÅÀº

±×·¯³ª

mysql> create database blog_development 

µîÀ¸·Î MySQLÀº ±×°ÍÀ» ¸¸µç 0 rows affected ¸Þ½ÃÁö°¡ SQL¿¡¼­ º¼ ¼ö ÀÖ½À´Ï´Ù ³Ê´Â Àͼ÷ÇØ Á®¾ß ÇÒ ·¹ÀÏÀ» »ç¿ëÇÏ°íÀÖ´Ù.

$ rake db:create 

µ¿ÀÏÇÑ ÀÛ¾÷À» ¼öÇàÇÕ´Ï´Ù. ¿ì¸®´Â ¾Æ¹«Æ° µ¥ÀÌÅͺ£À̽º¿¡ ¾×¼¼½ºÇÏ·Á°í ÇÒ ¶§ ¹ß»ý

$ rake db:migrate # Run the database migration 
$ rake db:seed  # Run thew seeds file create statements 
$ rake db:drop  # Drop the database