Having WAMP installed when i try to type mysql in my windows command prompt it would give me the following error:
'mysql' is not recognized as an internal or external command, operable program or batch file.
This simply means that the ‘mysql’ excutable command file (mysql.exe) was not added to your system path therefore the system was unable to locate this file. To add the ‘mysql’ to system path try to locate the ‘mysql’ resident folder. In my case (Windows7) it was
Copy it (to clipboard) and go to Control Panel -> System and Security -> System and paste the copied folder path into Variable value: field of Edit System Variable pop up. Prefix it with a semi-colon (;) to separate it from other existing values (see image below – click to open larger image)
Restart the command prompt and typing ‘mysql’ should work now.