Answers for "set path=%PATH%;D:\xampp\mysql\bin;"

mysql' is not recognized as an internal or external command,

Simply type in command prompt :

set path=%PATH%;D:\xampp\mysql\bin;

Here I have used path started from D so I used D: , you can use C: or E:

add mysql to path

For windows users only!
I had a lot of trouble for this one, but I found the solution.
Visit this page: https://overiq.com/installing-mysql-windows-linux-and-mac/

And then follow the steps, but instead of putting this (in step 5):
C:\Program Files\MySQL\MySQL Server x.y\bin\mysql.exe

Put this:
C:\Program Files\MySQL\MySQL Server x.y\bin