What is mysql password if we install the mysql using shell script

Question

I am writing the shell script to automatically install all the required packages for PHP site, I have written the script to automate the installation. I am using below script to install the mysql without prompt for password:

#!/bin/sh
LOGFILEPATH=/home/philtracker/logs/logs.log
echo "Executing Installation script">>$LOGFILEPATH
for i in apache2 php5 libapache2-mod-php5  php5-json mysql-server apache2-mod-auth-mysql     php5-mysql
    do
        sudo apt-get -y install $i
        if [ $? -ne 0 ] ; then
            echo "$i: installation failed for $i">>$LOGFILEPATH 2>&1
        else
            echo "$i: Installation successful for $i">>$LOGFILEPATH 2>&1
    fi
done

The above script installing the all packages successfully, But as I have automated the installation for MYSQL I don't have a password to login to mysql. Is there any default password set by MySQL ?

on a fresh/clean install, the root account usually has no password. — Marc B
– Marc B, Commented May 2, 2014 at 14:52
I can do a trick using script to reset the password of root user but I want to check if there is any other alternative — Ganesh Ghalame
– Ganesh Ghalame, Commented May 2, 2014 at 14:53

Hituptony · Accepted Answer · 2014-05-02 15:09:21Z

1

I believe it's root/root...or it's blank!

You can also directly update the password:

UPDATE
   mysql.user
SET
   Password=PASSWORD('MyNewPass')
WHERE
   User='root'; FLUSH PRIVILEGES;

http://www.thegeekstuff.com/2009/01/15-practical-usages-of-mysqladmin-command-for-administering-mysql-server/

edited May 2, 2014 at 15:09

answered May 2, 2014 at 14:52

Hituptony

2,8703 gold badges26 silver badges44 bronze badges

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

4 Comments

Ganesh Ghalame Over a year ago

Yes, I can do this to reset the password, I have tried this and it works but I am thinking if I have any default password then I can skip change password. Both root/root...or blank isn't working

Ganesh Ghalame Over a year ago

For running above command I need to first login in to mysql and I can't as I don't have a password to log in

Hituptony Over a year ago

blank should be default - root/toor is only other immediate suggestion...let me ask my old dba.

Ganesh Ghalame Over a year ago

thanks, It works It was my mistake I was using "mysql -uroot -p" instead of using "mysql -uroot" only.

Collectives™ on Stack Overflow

What is mysql password if we install the mysql using shell script

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related