Home / server / Questions / 322400
Accepted
rascher
Asked: 2011-10-18 17:39:12 +0800 CST

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

  • 772

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?

mysql password ubuntu-10.04

1 Answers

  1. Best Answer

    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

    • 7