Encrypt MySQL password using mysql_config_editor on client side

Connecting to MySQL without entering the password using mysql_config_editor

mysql_config_editor  Ver 8.0.22 for Linux on x86_64 (MySQL Community Server - GPL)

Copyright (c) 2012, 2020, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

MySQL Configuration Utility.

Usage: mysql_config_editor [program options] [command [command options]]

  -#, --debug[=#]     This is a non-debug version. Catch this and exit.

  -?, --help          Display this help and exit.

  -v, --verbose       Write more information.

  -V, --version       Output version information and exit.

Variables (--variable-name=value)

and boolean options {FALSE|TRUE}  Value (after reading options)

--------------------------------- ----------------------------------------

verbose                           FALSE

Where command can be any one of the following :

       set [command options]     Sets user name/password/host name/socket/port

                                 for a given login path (section).

       remove [command options]  Remove a login path from the login file.

       print [command options]   Print all the options for a specified

                                 login path.

       reset [command options]   Deletes the contents of the login file.

       help                      Display this usage/help information.