Setting up custom groups in .my.cnf?

Question

How to get emacs 'sql-mysql' (or mysql, for that matter) to read a user group from .my.cnf?

I have different options when calling mysql from cli and inside emacs, and I was wondering if I can achieve this using a user group in .my.cnf, i.e. something like:

[Emacs] Options ...

In general, can I ask the mysql client to read the user group?

Cheers, Dan.

Answer 1

In general, yes, you can add custom groups to my.cnf. This article explains how.