Getting MySQL path in command prompt

Question

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?

Answer 1

(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.