mysql is prompting for password even though my password is empty

Question

I installed mysql on ubuntu server and did not specify password. When I do

mysql -u root -p  

it prompts for password and without providing any input I just hit enter and it works.

Now I need to perform some operation on the database using cron job. My cron job does not work because mysql prompts for a password. I tried doing

mysql -u root -p'' my_database 

but that did not work either.

Any suggestion?

Answer 1

Go like this mysql -u root --password="" dbname