Install mysql-server and set password from the command line?

Question

I am installing MySQL via the command line: sudo apt-get install mysql-server. During the installation process, it prompts me for a root password.

How can I specify the MySQL password without having to wait for the screen to pop up and ask me the password? Is there a parameter I can pass to apt-get to specify the MySQL root password so that I can write a script to perform the installation?

score 7 · Accepted Answer · edited Jun 11 '20 at 10:02

7

This should do it for you

echo mysql-server-5.1 mysql-server/root_password password PASSWORD | debconf-set-selections

echo mysql-server-5.1 mysql-server/root_password_again password PASSWORD | debconf-set-selections

apt-get install -y mysql-server

Obviously you would replace PASSWORD with whatever you would want your MySQL root password to be

edited Jun 11 '20 at 10:02

Community

1

answered Oct 18 '11 at 01:52

DKNUCKLES

4,028
9
47
60

Probably want to add `-y` to the install line for a scripted installation. – Shane Madden Oct 18 '11 at 01:57
Good catch Shane. I've edited my answer to reflect the change. – DKNUCKLES Oct 18 '11 at 02:02
perfect, thank you! I was not aware of the debconf-set-selections script. – rascher Oct 18 '11 at 02:50

Install mysql-server and set password from the command line?

1 Answers1