Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote -1 down vote favorite 
## connect to mysql and source backup file ##
USER="root"
PASS=""

mysql -u$USER -p$PASS database_name < backup.sql

Above is my shell script which I used to source database but still its asking for password. I just want to know how can I source database in case of blank password. If root password is not blank than it works fine.

share|improve this question
1  
An empty database password is not acceptable, ever, and and empty root password is completely unthinkable. – Michael - sqlbot Apr 28 at 14:02

2 Answers

up vote 1 down vote

If root has no password you could just do this:

mysql -u$USER database_name < backup.sql

If you want to code so that root can be given a password later, do this in the script

USER="root"
PASS=""
if [ "${PASS}" == "" ]
then
    PASSWORD=""
else
    PASSWORD="-p${PASS}"
if
mysql -u$USER $PASS database_name < backup.sql

Give it a Try !!!

CAVEAT

If is usually not a good idea to have root without a password. Please give it one.

share|improve this answer
up vote 0 down vote

Use --password instead of -p:

mysql "--username=$USER" "--password=$PASS" < backup.sql
share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.