Database-Using-Python-/create_database.py at main · obitorin07/Database-Using-Python- · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
from dotenv import dotenv_values
import mysql.connector

secret =dotenv_values('.secret_code')

user_name=secret['USER_NAME']
user_pass=secret['USER_PASSWORD']
user_host=secret['USER_HOST']

mydb =mysql.connector.connect(user=user_name,password=user_pass,host=user_host)

#creating cursor

cursor =mydb.cursor()

cursor.execute('CREATE DATABASE LEARN_MYSQL')

mydb.close()
cursor.close()

"""
mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| LEARN_MYSQL        |
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
5 rows in set (0.00 sec)
"""