Install MySQL on Ubuntu Natty without password prompt and using shell variable as password

Question

I'm trying to install MySQL on Ubuntu Natty from a shell script. However, I keep running into one major issue: when I try to define the password outside of the shell script.

Below is the code to my shell script (which I have saved in /etc/init.d/install_mysql:

export DEBIAN_FRONTEND=noninteractive
echo mysql-server-5.1 mysql-server/root_password password $dbpass | debconf-set-selections
echo mysql-server-5.1 mysql-server/root_password_again password $dbpass | debconf-set-selections
apt-get -y install mysql-server

So what I enter in the terminal is:

dbpass="mysqlpass"
chmod +x /etc/init.d/install_mysql
/etc/init.d/install_mysql

MySQL installs, but it installs without a password, so I can just do something like mysql -uroot to access mysql (which I don't want).

The funny thing is if I put the password in the shell script as regular text, it works ok. So if I my install script is as follows, everything works (i.e. I must specify a password to access mysql):

export DEBIAN_FRONTEND=noninteractive
echo mysql-server-5.1 mysql-server/root_password password mysqlpass | debconf-set-selections
echo mysql-server-5.1 mysql-server/root_password_again password mysqlpass | debconf-set-selections
apt-get -y install mysql-server

Is there a way I can use a shell script variable to define my password in the shell script, instead of entering the password literally?!

Thanks in advance.

EDIT:

I just edited the variable declaration $dbpass="mysqlpass" to dbpass="mysqlpass". It was a typo.

Ignacio Vazquez-Abrams · Accepted Answer · 2011-11-15 15:22:04Z

1

$dbpass="mysqlpass"

Yeah, this is several types of wrong. Variable names don't start with $, and variables won't be passed to the environment of subprocesses unless exported.

dbpass="mysqlpass"
export dbpass

Note that environment variables are not considered a secure mechanism for sharing data; you may want to retool your script to read the password from stdin instead, which would be a bit more secure.

answered Nov 15, 2011 at 15:22

Ignacio Vazquez-Abrams

804k160 gold badges1.4k silver badges1.4k bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

ObiHill Over a year ago

It was a typo, my apologies. I'm trying the suggestion you mentioned about using export, I'll let you know. Thanks.

ObiHill Over a year ago

Thanks a lot. It turns out export dbpass was just what I was looking for. It works like a charm now. Cheers.

Marc B · Accepted Answer · 2011-11-15 15:33:39Z

0

$dbpass="mysqlpass"

should be

dbpass="mysqlpass"

As you've written it, $dbpass will be evaluated, and isn't defined, so comes out as an empty variable, boiling down to

="mysqlpass"

well, since it was a typo, then here's the answer:

MySQL looks for the envvar MYSQL_PWD: http://dev.mysql.com/doc/refman/5.0/en/environment-variables.html

edited Nov 15, 2011 at 15:33

answered Nov 15, 2011 at 15:22

Marc B

362k44 gold badges433 silver badges508 bronze badges

1 Comment

ObiHill Over a year ago

It was a typo, sorry about that.

Collectives™ on Stack Overflow

Install MySQL on Ubuntu Natty without password prompt and using shell variable as password

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related