How can I use MySqlConnectOptions with a database_url

[fvzwieten]

I can only use a full database_url, like mysql://root:password@localhost/db. I want to disable_statement_logging.

How can I do this?

[zvolin]

you can use some crate for url handling, eg url.

let db_url = Url::parse("mysql://root:password@localhost/db").unwrap();
let conn = MySqlConnectOptions::new()
    .host(db_url.host())
    .username(db_url.username())
    .password(db_url.password())
    .database(db_url.path().strip_prefix("/").unwrap())
    .connect().await?;

Haven't tested but should work with little tuning