Mysql Remote database connect from terminal

To connect the remote database from your terminal the command is

user>mysql --host=hostname --user=root --password

To change the password from the mysql command prompt is

mysql>SET PASSWORD FOR root@localhost = OLD_PASSWORD('mypassword');