How to remove root and user password for mysql

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.


i guess kiran, i already replied in ur different post

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