Mysqldb usage in python and pythonmysqldb usage

Mysqldb usage in python and pythonmysqldb usage

1. Introduce the MySQLdb Library 

Import MySQLdb

2. Establish a connection with the database 
Conn = MySQLdb. connect (host = "localhost", user = "root", passwd = "<mysql password>", db = "<database_name>", charset = "utf8 ")
The connect method is used to establish a connection with the database, receive several parameters, and return the connection object.

Common parameters include
Host: specifies the Database host name. The local host is used by default.
User: Database login name. The default value is the current user.
Passwd: Password for database login. Empty by default.
Db: name of the database to be used. No default value exists.
Port: the TCP port used by the MySQL service. The default value is 3306.
Charset: Database encoding.