How to Automate MySQL Installation on Ubuntu Without Password Prompt?

Automating MySQL Installation on Ubuntu without Password Prompt

In Ubuntu, installing MySQL server using sudo apt-get install mysql requires manual password entry. However, this is impractical for scripting purposes. To automate the installation and eliminate the interactive password prompt, we can employ the following approach:

sudo debconf-set-selections <p>This method sets the root password for MySQL server before the installation process begins. Replace your_password with the desired password or leave it blank for a passwordless setup.</p><p>For specific MySQL server versions (e.g., 5.6), modify the commands accordingly:</p><pre class="brush:php;toolbar:false">sudo debconf-set-selections <p>For mysql-community-server, use these keys:</p><pre class="brush:php;toolbar:false">sudo debconf-set-selections <p>If your shell does not support here-strings, use echo ... | sudo debconf-set-selections or the following alternative:</p><pre class="brush:php;toolbar:false">cat <p>You can verify the set password using sudo debconf-get-selections | grep ^mysql. This technique allows you to automate MySQL server installation on Ubuntu without the need for user interaction during the password setup.</p>

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