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