在命令窗口中输入mysql命令时,提示“mysql不是内部命令也不是可运行的程序”,发现此问题是由于系统的环境变量中未配置MySQL安装目录可执行文件的路径,可是安装MySQL时是默认按照的,此时已经忘记了安装位置,各个盘符中找了一遍,都没有找到。那么要怎样找到其安装的路径呢?

只需登录终端,进入MySQL的命令行,然后输入命令:show variables like "%char%";

mysql> show variables like "%char%";
+--------------------------+----------------------------------------------+
| Variable_name            | Value                                        |
+--------------------------+----------------------------------------------+
| character_set_client     | gbk                                          |
| character_set_connection | gbk                                          |
| character_set_database   | utf8mb4                                      |
| character_set_filesystem | binary                                       |
| character_set_results    | gbk                                          |
| character_set_server     | utf8mb4                                      |
| character_set_system     | utf8                                         |
| character_sets_dir       | D:\MySQL\mysql-8.0.19-winx64\share\charsets\ |
+--------------------------+----------------------------------------------+
8 rows in set, 1 warning (0.02 sec)

character_sets_dir 就是安装路径