命令行模式：MySQL服务端的登录和退出

• 登录

mysql [-h127.0.0.1] [-P3306] -uroot -p[密码]
参数：
   -h : MySQL服务所在的主机IP
   -P : MySQL服务端口号， 默认3306
   -u : MySQL数据库用户名
   -p ： MySQL数据库用户名对应的密码
注释：
   1、[]内为可选参数，如果需要连接远程的MySQL，需要加上这两个参数来指定远程主机IP、端口，
      如果连接本地的MySQL，则无需指定这两个参数。
   2、使用这种方式进行连接时，需要安装完毕后配置PATH环境变量。

• 退出

exit
quit

• 示例

C:\Users\administrator>mysql -h127.0.0.1 -P9306 -uroot -pzs_20220101
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 20
Server version: 8.0.28 MySQL Community Server - GPL

Copyright (c) 2000, 2022, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> quit
Bye

• 错误

错误：端口错误-错误2003 (HY000):无法连接到MySQL服务器上的'127.0.0.1:8306' (10061)
C:\Users\administrator>mysql -h127.0.0.1 -P8306 -uroot -pzs_20220101
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1:8306' (10061)

错误：密码错误-错误1045(28000):用户“root”@“localhost”的访问被拒绝(使用的密码:YES)
C:\Users\administrator>mysql -h127.0.0.1 -P9306 -uroot -pys_20221101
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)