Install MySQL on Ubuntu without a password prompt

by 
sudo debconf-set-selections <<< 'mysql-server mysql-server/root_password password your_password'
sudo debconf-set-selections <<< 'mysql-server mysql-server/root_password_again password your_password'
sudo apt-get -y install mysql-server

For specific versions, such as mysql-server-5.6, you’ll need to specify the version in like this:

sudo debconf-set-selections <<< 'mysql-server-5.6 mysql-server/root_password password your_password'
sudo debconf-set-selections <<< 'mysql-server-5.6 mysql-server/root_password_again password your_password'
sudo apt-get -y install mysql-server-5.6

For mysql-community-server, the keys are slightly different:

sudo debconf-set-selections <<< 'mysql-community-server mysql-community-server/root-pass password your_password'
sudo debconf-set-selections <<< 'mysql-community-server mysql-community-server/re-root-pass password your_password'
sudo apt-get -y install mysql-community-server

Replace your_password with the desired root password. (it seems your_password can also be left blank for a blank root password.)

If your shell doesn’t support here-strings (zsh, ksh93 and bash support them), use:

echo ... | sudo debconf-set-selections

More Related Contents:

  1. MySQL treats password in script as database
  2. error: ‘Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)’ — Missing /var/run/mysqld/mysqld.sock
  3. MySQL: How to reset or change the MySQL root password?
  4. ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
  5. Remote Connections Mysql Ubuntu
  6. Suppress warning messages using mysql from within Terminal, but password written in bash script
  7. ERROR 1130 (HY000): Host ” is not allowed to connect to this MySQL server [duplicate]
  8. How do I know when my docker mysql container is up and mysql is ready for taking queries?
  9. How to insert BLOB and CLOB files in MySQL?
  10. Removing MySQL 5.7 Completely [closed]
  11. Bash script to insert values in MySQL
  12. How to get number of rows affected, while executing MySQL query from bash?
  13. MySQL fails on: mysql “ERROR 1524 (HY000): Plugin ‘auth_socket’ is not loaded”
  14. ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysql.sock’ (2)
  15. MYSql config bind-address set to 0.0.0.0 but netstat shows different on Ubuntu
  16. 1114 (HY000): The table is full
  17. UPDATE multiple tables in MySQL using LEFT JOIN
  18. How to raise an error within a MySQL function
  19. What is maximum query size for mysql?
  20. Finding all parents in mysql table with single query (Recursive Query)
  21. How do I retrieve my MySQL username and password?
  22. How to execute a MySQL command from a shell script?
  23. Select most common value from a field in MySQL
  24. MySQL join query using like?
  25. MySql Query: Select top 3 rows from table for each category
  26. MySQL Select Query – Get only first 10 characters of a value
  27. Create an index on a huge MySQL production table without table locking
  28. MySQL concurrency, how does it work and do I need to handle it in my application
  29. mysql select id and name from other table and join query
  30. What happens when I exhaust a bigint generated key? How to handle it?

Leave a Comment