在命令窗口中输入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 就是安装路径