MySQL Bugs: #116208: [Feature Request] option to store database name in .mylogin.cnf

Bug #116208	[Feature Request] option to store database name in .mylogin.cnf
Submitted:	24 Sep 2024 3:53	Modified:	24 Sep 2024 4:29
Reporter:	Andy Edwards	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: Command-line Clients	Severity:	S4 (Feature request)
Version:	8.0.36, 8.0	OS:	Any
Assigned to:		CPU Architecture:	Any
Tags:	.mylogin.cnf mysql_config_editor

Description:
I would like to be able to store the database name in .mylogin.cnf so that I don't have to type it when using `mysql --login-path`.  For example, I wish I could:

```
$ mysql_config_editor set --login-path=foo --user=dbuser --host=127.0.0.1 --dbname=foo -p
```

And then
```
$ mysql --login-path=foo

mysql> SELECT DATABASE();
+--------------------+
| DATABASE()         |
+--------------------+
| foo                |
+--------------------+
1 row in set (0.00 sec)
```

My actual database is `tcmacave_wordpress`, which is long enough to type that I wish I had the convenience of including it in the config.

How to repeat:
N/A, feature request

Hello Andy Edwards,

Thank you for the feature request!

regards,
Umesh