How to remove root and user password for mysql

Linux
#1

Hi friends

How to remove password for root and user in mysql. I am running some scripts to automate some daily reports for that I want to run mysql commands without password. please let me know how can I fetch data from database without pressing any key for password ASAP.

Thanks
Kiran.

#2

i guess kiran, i already replied in ur different post

#3

Hi praduman it is already created post I will check tonight and let you know.

Thanks