Connect to MySQL/MariaDB from command line client using URI connection string?

Question

A database connection string given the URI pattern:

mysql://<user>:<pass>@<host>:<port>/<database>

Is there a way to use this string directly in the MySQL command line client without breaking it into the familiar mysql -u -h -p ... Format? < /p>

I found some discussion about this here, but the suggested option --uri does not exist in my client (mysql Ver 15.1 Distrib 10.11.2-MariaDB).

Answer 1

You must use mysqlsh (mysql shell) instead of mysql.

Use the --uri=<您的连接字符串> option.

https://dev.mysql.com /doc/mysql-shell/8.0/en/mysqlsh.html#option_mysqlsh_uri