MySQL Connector/Python :: 8 Connector/Python API Reference :: 8.2 Class connection.MySQLConnection :: 8.2.3 Method MySQLConnection.config(**kwargs)

8.2.4 Method MySQLConnection.connect(**kwargs) »

Section Navigation [Toggle]

8.2 Class connection.MySQLConnection
8.2.1 Constructor connection.MySQLConnection(**kwargs)
8.2.2 Method MySQLConnection.close()
8.2.3 Method MySQLConnection.config(**kwargs)
8.2.4 Method MySQLConnection.connect(**kwargs)
8.2.5 Method MySQLConnection.commit()
8.2.6 Method MySQLConnection.cursor(buffered=None, raw=None, cursor_class=None)
8.2.7 Method MySQLConnection.cmd_change_user(username='', password='', database='', charset=33)
8.2.8 Method MySQLConnection.cmd_debug()
8.2.9 Method MySQLConnection.cmd_init_db(database)
8.2.10 Method MySQLConnection.cmd_ping()
8.2.11 Method MySQLConnection.cmd_process_info()
8.2.12 Method MySQLConnection.cmd_process_kill(mysql_pid)
8.2.13 Method MySQLConnection.cmd_quit()
8.2.14 Method MySQLConnection.cmd_query(statement)
8.2.15 Method MySQLConnection.cmd_query_iter(statement)
8.2.16 Method MySQLConnection.cmd_refresh(options)
8.2.17 Method MySQLConnection.cmd_shutdown()
8.2.18 Method MySQLConnection.cmd_statistics()
8.2.19 Method MySQLConnection.disconnect()
8.2.20 Method MySQLConnection.get_rows(count=None)
8.2.21 Method MySQLConnection.get_row()
8.2.22 Method MySQLConnection.get_server_info()
8.2.23 Method MySQLConnection.get_server_version()
8.2.24 Method MySQLConnection.is_connected()
8.2.25 Method MySQLConnection.isset_client_flag(flag)
8.2.26 Method MySQLConnection.ping(attempts=1, delay=0)
8.2.27 Method MySQLConnection.reconnect(attempts=1, delay=0)
8.2.28 Method MySQLConnection.rollback()
8.2.29 Method MySQLConnection.set_charset_collation(charset=None, collation=None)
8.2.30 Method MySQLConnection.set_client_flags(flags)
8.2.31 Property MySQLConnection.autocommit
8.2.32 Property MySQLConnection.charset_name
8.2.33 Property MySQLConnection.collation_name
8.2.34 Property MySQLConnection.connection_id
8.2.35 Property MySQLConnection.database
8.2.36 Property MySQLConnection.get_warnings
8.2.37 Property MySQLConnection.raise_on_warnings
8.2.38 Property MySQLConnection.server_host
8.2.39 Property MySQLConnection.server_port
8.2.40 Property MySQLConnection.sql_mode
8.2.41 Property MySQLConnection.time_zone
8.2.42 Property MySQLConnection.unix_socket
8.2.43 Property MySQLConnection.user

8.2.3. Method `MySQLConnection.config(**kwargs)`

Configures a MySQLConnection instance after it has been instantiated. See Chapter 7, Connector/Python Connection Arguments for a complete list of possible arguments.

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

cnx = MySQLConnection(user='joe', database='test')
# Connected as 'joe'
cnx.config(user='jane')
cnx.reconnect()
# Now connected as 'jane'

Previous / Next / Up / Table of Contents

User Comments

Add your own comment.

Top / Previous / Next / Up / Table of Contents

8.2.3. Method MySQLConnection.config(**kwargs)

User Comments

8.2.3. Method `MySQLConnection.config(**kwargs)`