How to Automate MySQL Installation on Ubuntu Without Password Prompts?

Automating MySQL Installation on Ubuntu without Password Prompts

Installing MySQL server on Ubuntu using the command sudo apt-get install mysql requires a password to be entered manually. To streamline this process and eliminate the need for user interaction, a script can be created to provide the password automatically.

Script Syntax

The following script will install MySQL server and assign a custom password to the root user:

sudo debconf-set-selections <p><strong>Explanation</strong></p>

• sudo debconf-set-selections is used to set debconf configuration values.
• The
• mysql-server/root_password and mysql-server/root_password_again are the configuration keys.
• your_password is the desired root password.

Specific Version Support

For specific MySQL versions, such as 5.6, specify the version in the configuration keys:

sudo debconf-set-selections <p><strong>MySQL Community Server</strong></p><p>For MySQL Community Server, the configuration keys are slightly different:</p><pre class="brush:php;toolbar:false">sudo debconf-set-selections <p><strong>Alternative Shell Syntax</strong></p><p>If your script is using a non-bash shell, use the following syntax to pass multiline strings:</p><pre class="brush:php;toolbar:false">echo ... | sudo debconf-set-selections 

Or, using heredocs (requires bash, zsh, or ksh93 shell):

cat <p><strong>Verification</strong></p><p>To check if the configuration was set correctly, run the following command:</p><pre class="brush:php;toolbar:false">sudo debconf-get-selections | grep ^mysql

This should output the values set for the MySQL configuration keys.

The above is the detailed content of How to Automate MySQL Installation on Ubuntu Without Password Prompts?. For more information, please follow other related articles on the PHP Chinese website!