Non-Interactive Installation of MySQL on Ubuntu

The standard method of installing MySQL server on Ubuntu using sudo apt-get install mysql prompts for a password in the console, which can be inconvenient when writing scripts for automated installations.

Using debconf-set-selections

To avoid the password prompt during installation, you can use the debconf-set-selections command to preconfigure the password for the MySQL root user. This requires the following steps:

sudo debconf-set-selections 
In this script, replace your_password with the desired root password. Note: it is also possible to leave your_password blank to set the root password to empty.
Specific MySQL Versions
If you need to install a specific version of MySQL, such as MySQL 5.6, specify the version in the debconf-set-selections command as follows:
sudo debconf-set-selections 
MySQL Community Server
For MySQL community editions, the debconf-set-selections keys differ slightly:
sudo debconf-set-selections 
Here-Strings in Non-Bash Shells
Some shells, such as dash or ash, do not support here-strings. In these cases, use the following:
echo ... | sudo debconf-set-selections 
Or, write multiline strings using:
cat 
Verification
To check the configured root password, use the debconf-get-selections command:
$ sudo debconf-get-selections | grep ^mysql
mysql-server    mysql-server/root_password_again    password    your_password
mysql-server    mysql-server/root_password  password    your_password