FilesExpand file tree

 master

/

python_mysql_connect2.py

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

25 lines (19 loc) · 504 Bytes

 master

/

python_mysql_connect2.py

Copy path

Top

File metadata and controls

• Code
• Blame

25 lines (19 loc) · 504 Bytes

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

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

from mysql.connector import MySQLConnection,Error

from python_mysql_dbconfig import read_db_config

def connect():

""" connect to MySQL database """

db_config = read_db_config()

try:

print('Connecting to MySQL database...')

conn = MySQLConnection(**db_config)

if conn.is_connected():

print('connection established.')

else:

print('connection failed.')

except Error as error:

print(error)

finally:

conn.close()

print('Connection closed.')

if __name__ == '__main__':

connect()