10.2.4 MySQLConnection.config() Method

Syntax:

Press CTRL+C to copy
 
cnx.config(**kwargs)

Configures a MySQLConnection instance after it has been instantiated. For a complete list of possible arguments, see Section 7.1, “Connector/Python Connection Arguments”.

Arguments:

• kwargs: Connection arguments.

You could use the config() method to change (for example) the user name, then call reconnect().

Example:

Press CTRL+C to copy
 
cnx = mysql.connector.connect(user='joe', database='test')
# Connected as 'joe'
cnx.config(user='jane')
cnx.reconnect()
# Now connected as 'jane'

For a connection obtained from a connection pool, config() raises an exception. See Section 9.5, “Connector/Python Connection Pooling”.