mysql -u alice -p -h db.example.com mydb

mysql is MySQL and MariaDB's interactive client; -u names the user, -p prompts for the password, and -h the server host. The final argument selects the mydb database. Add -P for a custom port. Related: mysql -e for one-shot statements.