mysql获取路径,在命令提示符下获取MySQL路径

How can I get the mysql installation path up to bin folder using command prompt in windows.Is there any command to get the location of mysql installation path?

解决方案

(if I get your question correctly)

Like you wold add any other directory to path

set PATH=%PATH%;C:\DirectoryToAdd\ToPath

It doesnt metter if you add %PATH% on, beginig or on the end, but you must add it, otherwise your path will only be your new directory.

Find mySql installation directory ( for example C:\Program Files\MySQL\MySQL Server 5.6\bin) and then type the comand above

set PATH=%PATH%;C:\Program Files\MySQL\MySQL Server 5.6\bin

tips:

in cmd use PATH to see what is your path (I think every body knows this, but it cant hurt) And see something more about PATH command

Your mySql servce must be turned on to execute commands.

In Windows explorer if you type cmd.exe in Windwos Explorer Address

Bar you will get cmd running from that directory.