When I install mysql-client and/or mysql-server on Linux it prompts me for a root password on installation. I'm wondering when people automate this process, for example by using something like Terraform, how is this managed?
For example, if whatever package management system you are using runs the following command, is there anything that can be added to the command to use an environment variable, or a value in the configuration, file so that the password is defined before (in the config), and set during the installation process?
sudo apt-get install mysql-client