Django Tutorial - #2 database 생성

brian·2022년 5월 4일
0

django tutorial

목록 보기
2/5

2. Database 생성

1) mysql 설치

>>> brew install mysql

2) database 생성

데이터베이스 생성 : mysql -u root -p
mysql > create database name character set utf8mb4 collate utf8mb4_general_ci;

>>>> mysql --version # mysql version check               
mysql  Ver 8.0.29 for macos12.2 on arm64 (Homebrew)

>>>> mysql -u root -p # create Database                                  
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is ###
Server version: 8.0.29 MySQL Community Server - GPL

Copyright (c) 2000, 2022, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> create database db_django_tuto character set utf8mb4 collate utf8mb4_general_ci;
Query OK, 1 row affected (0.01 sec)

Query OK ! 라고 뜬 걸 보니 성공한 것 같다.

(에러발생시) mysql.server start 확인!

3) database 확인

mysql> show databases;

>>> show databases;
+--------------------+
| Database           |
+--------------------+
| db_django_tuto     |

조금 전에 만든 db_django_tuto 가 들어있는 걸 확인할 수 있다.

0개의 댓글