mysql 5.7下已经添加了环境变量，但是还是出现‘mysql' is not recognize

[kgarnett29]

我的版本是5.7，现在环境变量全都添加好了，Win目录下打开MySQL 5.7 command line使用正常从mysql server 5.7的bin目录下可以使用mysql -uroot -p的命令，但是在默认目录下就不能，。

请问怎么解决这个问题？
以下是环境变量中关于mysql的部分

...C:\Program Files (x86)\MySQL\MySQL Fabric 1.5 & MySQL Utilities 1.5\;C:\Program Files (x86)\MySQL\MySQL Fabric 1.5 & MySQL Utilities 1.5\Doctrine extensions for PHP\; C:\Program Files\MySQL\MySQL Server 5.7\bin;

[小灸舞]

LZ的环境变量应该是OK的
不知道LZ有没有关掉以后重新打开DOS命令窗口？

[ACMAIN_CHM]

DOS下PATH，然后贴出以供分析。

Microsoft Windows [Version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation.  All rights reserved.

C:\Users\admin>path
PATH=C:\Windows\System32;C:\Windows;C:\Windows\system32\wbem;c:\Program Files (x
Management Engine Components\DAL;C:\Program Files\Intel\Intel(R) Management Engi
ram Files\Microsoft SQL Server\110\Tools\Binn\;C:\Program Files (x86)\Microsoft
Server\100\DTS\Binn\;c:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\

C:\Users\admin>

[kgarnett29]

引用 2 楼 ACMAIN_CHM 的回复:

DOS下PATH，然后贴出以供分析。

Microsoft Windows [Version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation.  All rights reserved.

C:\Users\admin>path
PATH=C:\Windows\System32;C:\Windows;C:\Windows\system32\wbem;c:\Program Files (x
Management Engine Components\DAL;C:\Program Files\Intel\Intel(R) Management Engi
ram Files\Microsoft SQL Server\110\Tools\Binn\;C:\Program Files (x86)\Microsoft
Server\100\DTS\Binn\;c:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\

C:\Users\admin>

你好，我的是这样的： Microsoft Windows [Version 6.1.7601] Copyright (c) 2009 Microsoft Corporation. All rights reserved. C:\Users\***>path PATH=C:\Program Files (x86)\RSA SecurID Token Common;C:\Program Files (x86)\Inte l\iCLS Client\;C:\Program Files\Intel\iCLS Client\;C:\WINDOWS\system32;C:\WINDOW S;C:\WINDOWS\System32\Wbem;%mysql%;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C :\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Microsoft Appl ication Virtualization Client;C:\Program Files\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files\Intel\Intel(R) Management Engine Components\IPT; C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\DAL;C:\Progra m Files (x86)\Intel\Intel(R) Management Engine Components\IPT;C:\Program Files ( x86)\Skype\Phone\;C:\Program Files (x86)\RSA SecurID Token Common\;C:\Python27;C :\Program Files (x86)\MySQL\MySQL Fabric 1.5 & MySQL Utilities 1.5\;C:\Program F iles (x86)\MySQL\MySQL Fabric 1.5 & MySQL Utilities 1.5\Doctrine extensions for PHP\; C:\Program Files\MySQL\MySQL Server 5.7\bin; C:\Users\***>

[kgarnett29]

引用 1 楼 qq423399099 的回复:

LZ的环境变量应该是OK的 不知道LZ有没有关掉以后重新打开DOS命令窗口？

嗯，重启电脑也试过了- -||

[ACMAIN_CHM]

把红色部分去掉。 另外搜索一下 mysql.exe在哪个目录下。 C:\Users\***>path PATH=C:\Program Files (x86)\RSA SecurID Token Common;C:\Program Files (x86)\Inte l\iCLS Client\;C:\Program Files\Intel\iCLS Client\;C:\WINDOWS\system32;C:\WINDOW S;C:\WINDOWS\System32\Wbem;%mysql%;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C :\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Microsoft Appl ication Virtualization Client;C:\Program Files\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files\Intel\Intel(R) Management Engine Components\IPT; C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\DAL;C:\Progra m Files (x86)\Intel\Intel(R) Management Engine Components\IPT;C:\Program Files ( x86)\Skype\Phone\;C:\Program Files (x86)\RSA SecurID Token Common\;C:\Python27;C :\Program Files (x86)\MySQL\MySQL Fabric 1.5 & MySQL Utilities 1.5\;C:\Program F iles (x86)\MySQL\MySQL Fabric 1.5 & MySQL Utilities 1.5\Doctrine extensions for PHP\; C:\Program Files\MySQL\MySQL Server 5.7\bin;

[kgarnett29]

引用 5 楼 ACMAIN_CHM 的回复:

把红色部分去掉。 另外搜索一下 mysql.exe在哪个目录下。 C:\Users\***>path PATH=C:\Program Files (x86)\RSA SecurID Token Common;C:\Program Files (x86)\Inte l\iCLS Client\;C:\Program Files\Intel\iCLS Client\;C:\WINDOWS\system32;C:\WINDOW S;C:\WINDOWS\System32\Wbem;%mysql%;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C :\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Microsoft Appl ication Virtualization Client;C:\Program Files\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files\Intel\Intel(R) Management Engine Components\IPT; C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\DAL;C:\Progra m Files (x86)\Intel\Intel(R) Management Engine Components\IPT;C:\Program Files ( x86)\Skype\Phone\;C:\Program Files (x86)\RSA SecurID Token Common\;C:\Python27;C :\Program Files (x86)\MySQL\MySQL Fabric 1.5 & MySQL Utilities 1.5\;C:\Program F iles (x86)\MySQL\MySQL Fabric 1.5 & MySQL Utilities 1.5\Doctrine extensions for PHP\; C:\Program Files\MySQL\MySQL Server 5.7\bin;

一开始没有红色部分的不行，所以我加上去的想试试。MySQL.exe就是在C:\Program Files\MySQL\MySQL Server 5.7\bin\下。刚才贴出来最后少了个“\”，加了也不对……

[ACMAIN_CHM]

贴出去掉红色部分的 PATH 另外贴出 dir "C:\Program Files\MySQL\MySQL Server 5.7\bin\mysql.exe"

[kgarnett29]

引用 7 楼 ACMAIN_CHM 的回复:

贴出去掉红色部分的 PATH 另外贴出 dir "C:\Program Files\MySQL\MySQL Server 5.7\bin\mysql.exe"

C:\Users\kaizhu>dir "C:\Program Files\MySQL\MySQL Server 5.7\bin\mysql.exe" Volume in drive C is OSDisk Volume Serial Number is A292-CE05 Directory of C:\Program Files\MySQL\MySQL Server 5.7\bin 2016/02/02 02:23 5,443,584 mysql.exe 1 File(s) 5,443,584 bytes 0 Dir(s) 69,889,859,584 bytes free C:\Users\kaizhu>path PATH=C:\Program Files (x86)\RSA SecurID Token Common;C:\Program Files (x86)\Inte l\iCLS Client\;C:\Program Files\Intel\iCLS Client\;C:\WINDOWS\system32;C:\WINDOW S;C:\WINDOWS\System32\Wbem;%mysql%;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C :\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Microsoft Appl ication Virtualization Client;C:\Program Files\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files\Intel\Intel(R) Management Engine Components\IPT; C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\DAL;C:\Progra m Files (x86)\Intel\Intel(R) Management Engine Components\IPT;C:\Program Files ( x86)\Skype\Phone\;C:\Program Files (x86)\RSA SecurID Token Common\;C:\Python27;C :\Program Files (x86)\MySQL\MySQL Fabric 1.5 & MySQL Utilities 1.5\;C:\Program F iles (x86)\MySQL\MySQL Fabric 1.5 & MySQL Utilities 1.5\Doctrine extensions for PHP\; C:\Program Files\MySQL\MySQL Server 5.7\bin\; C:\Users\kaizhu>mysql 'mysql' is not recognized as an internal or external command, operable program or batch file.

[ACMAIN_CHM]

不是声称红包部分已经去掉了吗？ C:\Users\kaizhu>path PATH=C:\Program Files (x86)\RSA SecurID Token Common;C:\Program Files (x86)\Inte l\iCLS Client\;C:\Program Files\Intel\iCLS Client\;C:\WINDOWS\system32;C:\WINDOW S;C:\WINDOWS\System32\Wbem;%mysql%;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C :\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Microsoft Appl ication Virtualization Client;C:\Program Files\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files\Intel\Intel(R) Management Engine Components\IPT; C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\DAL;C:\Progra m Files (x86)\Intel\Intel(R) Management Engine Components\IPT;C:\Program Files ( x86)\Skype\Phone\;C:\Program Files (x86)\RSA SecurID Token Common\;C:\Python27;C :\Program Files (x86)\MySQL\MySQL Fabric 1.5 & MySQL Utilities 1.5\;C:\Program F iles (x86)\MySQL\MySQL Fabric 1.5 & MySQL Utilities 1.5\Doctrine extensions for PHP\; C:\Program Files\MySQL\MySQL Server 5.7\bin\;