python-mysqlHow can I set a timeout for a MySQL connection in Python?

To set a timeout for a MySQL connection in Python, you can use the connect() method from the MySQLdb module. This method takes an optional connect_timeout parameter which specifies the timeout in seconds.

For example:

import MySQLdb

db = MySQLdb.connect(host="localhost", user="user", passwd="password", connect_timeout=5)

This will set the connection timeout to 5 seconds.

The connect() method also takes other optional parameters such as db, port, unix_socket, charset, sql_mode, read_default_file, conv, use_unicode, client_flag, cursorclass, init_command, ssl and read_default_group.

For more information, see the following links:

• MySQLdb.connect()
• MySQL Python Connector

Edit this code on GitHub