Perfect way to login to MySQL (windows) through command prompt

Use this : mysql -u user_name -p [press_enter_key]

then type password

Example

D:\xampp\mysql\bin\mysql -u root -p  [press_enter_key]

Enter password: *********