Struct sqlx::mysql::MySqlConnectOptions

pub struct MySqlConnectOptions { /* fields omitted */ }

This is supported on crate feature mysql only.

Options and flags which can be used to configure a MySQL connection.

A value of MySqlConnectOptions can be parsed from a connection URI, as described by MySQL.

The generic format of the connection URL:

mysql://[host][/database][?properties]

Properties

Parameter	Default	Description
ssl-mode	PREFERRED	Determines whether or with what priority a secure SSL TCP/IP connection will be negotiated. See MySqlSslMode.
ssl-ca	None	Sets the name of a file containing a list of trusted SSL Certificate Authorities.
statement-cache-capacity	100	The maximum number of prepared statements stored in the cache. Set to 0 to disable.
socket	None	Path to the unix domain socket, which will be used instead of TCP if set.

Example

// URI connection string
let conn = MySqlConnection::connect("mysql://root:password@localhost/db").await?;

// Manually-constructed options
let conn = MySqlConnectOptions::new()
    .host("localhost")
    .username("root")
    .password("password")
    .database("db")
    .connect().await?;

Implementations

impl MySqlConnectOptions

pub fn new() -> MySqlConnectOptions

Creates a new, default set of options ready for configuration

pub fn host(self, host: &str) -> MySqlConnectOptions

Sets the name of the host to connect to.

The default behavior when the host is not specified, is to connect to localhost.

pub fn port(self, port: u16) -> MySqlConnectOptions

Sets the port to connect to at the server host.

The default port for MySQL is 3306.

pub fn socket(self, path: impl AsRef<Path>) -> MySqlConnectOptions

Pass a path to a Unix socket. This changes the connection stream from TCP to UDS.

By default set to None.

pub fn username(self, username: &str) -> MySqlConnectOptions

Sets the username to connect as.

pub fn password(self, password: &str) -> MySqlConnectOptions

Sets the password to connect with.

pub fn database(self, database: &str) -> MySqlConnectOptions

Sets the database name.

pub fn ssl_mode(self, mode: MySqlSslMode) -> MySqlConnectOptions

Sets whether or with what priority a secure SSL TCP/IP connection will be negotiated with the server.

By default, the SSL mode is Preferred, and the client will first attempt an SSL connection but fallback to a non-SSL connection on failure.

Example

let options = MySqlConnectOptions::new()
    .ssl_mode(MySqlSslMode::Required);

pub fn ssl_ca(self, file_name: impl AsRef<Path>) -> MySqlConnectOptions

Sets the name of a file containing a list of trusted SSL Certificate Authorities.

Example

let options = MySqlConnectOptions::new()
    .ssl_mode(MySqlSslMode::VerifyCa)
    .ssl_ca("path/to/ca.crt");

pub fn ssl_ca_from_pem(
    self,
    pem_certificate: Vec<u8, Global>
) -> MySqlConnectOptions

Sets PEM encoded list of trusted SSL Certificate Authorities.

Example

let options = MySqlConnectOptions::new()
    .ssl_mode(MySqlSslMode::VerifyCa)
    .ssl_ca_from_pem(vec![]);

pub fn statement_cache_capacity(self, capacity: usize) -> MySqlConnectOptions

Sets the capacity of the connection's statement cache in a number of stored distinct statements. Caching is handled using LRU, meaning when the amount of queries hits the defined limit, the oldest statement will get dropped.

The default cache capacity is 100 statements.

pub fn charset(self, charset: &str) -> MySqlConnectOptions

Sets the character set for the connection.

The default character set is utf8mb4. This is supported from MySQL 5.5.3. If you need to connect to an older version, we recommend you to change this to utf8.

pub fn collation(self, collation: &str) -> MySqlConnectOptions

Sets the collation for the connection.

The default collation is derived from the charset. Normally, you should only have to set the charset.

Trait Implementations

impl Clone for MySqlConnectOptions

pub fn clone(&self) -> MySqlConnectOptions

Returns a copy of the value.

pub fn clone_from(&mut self, source: &Self)

Performs copy-assignment from source.

impl ConnectOptions for MySqlConnectOptions

type Connection = MySqlConnection

pub fn connect(
    &self
) -> Pin<Box<dyn Future<Output = Result<<MySqlConnectOptions as ConnectOptions>::Connection, Error>> + Send, Global>> where
    <MySqlConnectOptions as ConnectOptions>::Connection: Sized, 

Establish a new database connection with the options specified by self.

pub fn log_statements(&mut self, level: LevelFilter) -> &mut MySqlConnectOptions

Log executed statements with the specified level

pub fn log_slow_statements(
    &mut self,
    level: LevelFilter,
    duration: Duration
) -> &mut MySqlConnectOptions

Log executed statements with a duration above the specified duration at the specified level.

pub fn disable_statement_logging(&mut self) -> &mut Self

Entirely disables statement logging (both slow and regular).

impl Debug for MySqlConnectOptions

pub fn fmt(&self, f: &mut Formatter<'_>) -> Result<(), Error>

Formats the value using the given formatter.

impl Default for MySqlConnectOptions

pub fn default() -> MySqlConnectOptions

Returns the "default value" for a type.

impl From<MySqlConnectOptions> for AnyConnectOptions

pub fn from(options: MySqlConnectOptions) -> AnyConnectOptions

Performs the conversion.

impl FromStr for MySqlConnectOptions

type Err = Error

The associated error which can be returned from parsing.

pub fn from_str(s: &str) -> Result<MySqlConnectOptions, Error>

Parses a string s to return a value of this type.