skip mysql password in bash script when password is empty

Question

I have a bash file db_reset

drop database foo;
create database foo;

And I am trying to run this script:

prompt> mysql -uroot -p < db_reset

the password is requested every time

prompt> mysql -uroot -p < db_reset
Enter password:

And I want to skip this step. Password is empty. I've tried with solutions like

prompt> mysql -uroot -p"" < db_reset
Enter password:

but the result is always the same. Can someone help me?

spencer7593 · Accepted Answer · 2016-10-03 21:01:23Z

2

If you don't want to supply a password, just omit (leave off) the -p option

:~$ mysql -u root

N.B. A blank password is not secure. If this was my database, there's no way that there would be root account, or any account, without a password or other secure authentication mechanism. (MySQL shouldn't even allow connections without authentication.)

edited Oct 3, 2016 at 21:01

answered Oct 3, 2016 at 20:55

spencer7593

109k15 gold badges122 silver badges148 bronze badges

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

1 Comment

sensorario Over a year ago

Uh, thanks. I have been thought that with empty password, -p was still required in bash commands. thanks.

Collectives™ on Stack Overflow

skip mysql password in bash script when password is empty

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related