Python3 connecting MySQL

1. Install pymysql;

The 2.mac version is as follows:

1 #-*-coding:utf-8-*-2 ImportPymysql3# The password I use * mosaic wow haha4conn = Pymysql.connect (host ='127.0.0.1', Unix_socket ='/tmp/mysql.sock', user ='Root', password ='******', db ='MySQL', CharSet ='utf8s')5Cur =conn.cursor ()6Cur.execute ("Use MySQL")7 8Cur.execute ("SELECT * from user")9 Print(Cur.fetchone ())Ten cur.close () OneConn.close ()

3. The Windows edition is as follows:

Note: Write int instead of STR after 1.port;

2. Add charset= ' UTF8 ' to ensure that the detected Chinese characters can be displayed normally;

1 #-*-coding:utf-8-*-2 ImportPymysql3 4conn = Pymysql.connect (host ='XXXXXX', port = 1234, user ='****', password ='*****', db ='xxxx', CharSet ='UTF8')5Cur =conn.cursor ()6Cur.execute ("Use xxxx")7 8Cur.execute ("SELECT * from xxxx where id = 1039")9 Print(Cur.fetchone ())Ten cur.close () OneConn.close ()

Python3 connecting MySQL