how directly login to mysql database without password prompt

how directly login to mysql database without password prompt

#mysql -Dmy_database -uroot -p123456 <-------

we can use this command to login to a mysql database and do some operations, using shell script.

------------------ Shell Script

1)create a file mysql_login.sh

2)Then type following line in it .
mysql -Dmy_database -uroot -p123456

3)save file

4)#chmod 777 mysql_login.sh

5)./mysql_login.sh <------ To run script

---------------------