Python with MySQL

(참고) DB backup,restore 다룰 때 만들었던 sql_ws에서 예제를 다룸

#### 파이썬에서 mysql 설치
!pip install pip install mysql-connector-python
import mysql.connector

#### Create Connection 예제1
# Local Database 연결
local = mysql.connector.connect (
    host = "localhost",
    user = "root",
    password = "*****"
)

#### Create Connection 예제2
# AWS RDS(database-1)연결
remote = mysql.connector.connect (
    host = "database-1.c5y2s46i0az1.us-east-2.rds.amazonaws.com",
    port = 3306,
    user = "admin",
    password = "*****"
)

#### Close Database
local.close()
remote.close()


#### Create Connection 예제1
# Local MySQL의 zerobase(database)에 연결
Local = mysql.connector.connect(
    host = "localhost",
    user = "root",
    password = "sb0305!",
    database = "zerobase"
)
Local.close()


#### Create Connection 예제2
# AWS RDS(database-1) zerobase(database)에 연결
remote = mysql.connector.connect (
    host = "database-1.c5y2s46i0az1.us-east-2.rds.amazonaws.com",
    port = 3306,
    user = "admin",
    password = "sbsb0305!",
    database = "zerobase"
)
remote.close()