mysql fabric python_python---连接MySQL第五页

Connector/Python Connection Arguments

A connection with the MySQL server can be established using either the mysql.connector.connect() function or the mysql.connector.MySQLConnection() class:

Press CTRL+C to copy

cnx = mysql.connector.connect(user='joe', database='test')

cnx = MySQLConnection(user='joe', database='test')

The following table describes the arguments that can be used to initiate a connection. An asterisk (*) following an argument indicates a synonymous argument name, available only for compatibility with other Python MySQL drivers. Oracle recommends not to use these alternative names.

Table 7.1 Connection Arguments for Connector/Python

Argument NameDefaultDescription

user (username*)

The user name used to authenticate with the MySQL server.

password (passwd*)

The password to authenticate the user with the MySQL server.

database (db*)

The database name to use when connecting with the MySQL server.

host

127.0.0.1

The host name or IP address of the MySQL server.

port

3306

The TCP/IP port of the MySQL server. Must be an integer.

unix_socket

The location of the Unix socket file.

auth_plugin

Authentication plugin to use. Added in 1.2.1.

use_unicode

True

Whether to use Unicode.

charset

utf8

Which MySQL character set to use.

collation

utf8_general_ci

Which MySQL collation to use.

autocommit

False

Whether to autocommit transactions.

time_zone

Set the time_zone session variable at connection time.

sql_mode

Set the sql_mode session variable at connection time.

get_warnings

False

Whether to fetch warnings.

raise_on_warnings

False

Whether to raise an exception on warnings.

connection_timeout (connect_timeout*)

Timeout for the TCP and Unix socket connections.

client_flags

MySQL client flags.

buffered

False

Whether cursor objects fetch the results immediately after executing queries.

raw

False

Whether MySQL results are returned as is, rather than converted to Python types.

ssl_ca

File containing the SSL certificate authority.

ssl_cert

File containing the SSL certificate file.

ssl_key

File containing the SSL key.

ssl_verify_cert

False

When set to True, checks the server certificate against the certificate file specified by the ssl_ca option. Any mismatch causes a ValueError exception.

force_ipv6

False

When set to True, uses IPv6 when an address resolves to both IPv4 and IPv6. By default,