I could've sworn I've blogged this before.

To log in with a specific user name and password, use the following syntax:

mysql -u my_user_name -p

This will force a password prompt.