MySQL commands for connecting to local databases and remote databases

1. MySQL connects to the local database. The username is "root" and the password is "123" (Note: there cannot be spaces between "-P" and "123)
C: \> mysql-H localhost-u root-p123
2. Connect MySQL to the remote database (192.168.0.201), Port "3306", username "root", password "123"
C: \> mysql-H 192.168.0.201-P 3306-u root-p123
3. MySQL connects to the local database. The user name is "root" and the password is hidden.
C: \> mysql-H localhost-u root-P
Enter password:
4. MySQL connects to the local database. The user name is "root" and the database to be connected is "test"
C: \> mysql-H localhost-u root-p123-D Test