Discussion on: How to securely login to MySQL without providing password each time

[Bobby Iliev]

Hi there 👋,

Very good question.

Yes, this is doable, you can specify a host and then have a suffix for each host in your config file.

Example:

• DB Host 1:

[clientdb1]
user=your_username
password=your_pass
host=db1.example.com

Note the client + db1 suffix, then to specify which SQL server you would like to connect to you need to use the --defaults-group-suffix= flag, for the above example it will look like this:

mysql --defaults-group-suffix=db1

To make things easier, you could also add a Bash alias for that command so that you don't have to type the whole thing each time.

Hope that this helps!

[Darshit Patel]

Thanks for the reply! I will try this out