Is is possible to set using password: NO when using MySQL?

[zshipko]

I am using sqlx to connect to MySQL for a user that has no password configured. Is there any way to connect with an empty password and using password: NO activated?

Thanks!

[mehcode]

@zshipko Marked the issue wrong in that commit but this is fixed in d820763

Thanks for the bug report.

[zshipko]

Awesome, thank you! I appreciate the quick response :-)

[distinctjuggle]

Am I doing something wrong, or is this broken again somehow?

I've tried quite a few different combinations and none seem to be handled properly.

They either are sending some password which is incorrect, or they are failing to properly read and handle the username:

let database_url = "mysql://username@localhost/database?user=username";
let database_url = "mysql://username:@localhost/database?user=username";
let database_url = "mysql://username:@localhost/database?password=";
let database_url = "mysql://username:''@localhost/database?password=";
let database_url = "mysql://'username':@localhost/database?password="

I've probably tried a few others as well, but I can't seem to get it to pass it over properly. I'll always end up with either the, "wrong" password (read: a password which isn't blank), or the username not being recognized and thus resulting in an error like: "Access denied for user ''@'localhost' to database xxx

Is there something else I can try?