What is the equivalent for "--ssl" in the .myclirc config file?

[ericgray]

I am connecting to a MySQL server that has require_secure_transport=ON so I need to use mycli --ssl to connect, and it does work. However, I cannot determine where I can put this in the config file so I do not need it on the command line.

[rolandwalker]

Hi!

Yes, we ought to support something like ?ssl=True appended to the DSN, but looking at the code, the functionality isn't there yet. We can open an issue for it.

mycli/mycli/main.py

Lines 1284 to 1295 in aea28a4

	if dsn_uri:
	uri = urlparse(dsn_uri)
	if not database:
	database = uri.path[1:] # ignore the leading fwd slash
	if not user and uri.username is not None:
	user = unquote(uri.username)
	if not password and uri.password is not None:
	password = unquote(uri.password)
	if not host:
	host = uri.hostname
	if not port:
	port = uri.port

[ericgray]

Thanks for the response. I was trying to find a way to use "unmodified" connection string URLs (I intend to copy/paste them from another app) with mycli, by adding this --ssl equivalent to a the .myclirc.

For now I can just use a good old bash alias: alias mycli="mycli --ssl" to move forward. Thanks again.