Can't run MySQL from command prompt

Question

I downloaded MySQL 5.6.25 for Windowsx64 and I tried to run the command

mysql -uroot -p

to start using MySQL but it says

'mysql' is not recognized as an internal or external command, operable program or batch file.

Do I need to move MySQL to some other place? It is currently on the desktop.

EDIT: I downloaded Xampp but now when I run that same command I get this: enter image description here

Another solution would be running the command within the mysql's folder installation. — Eric Martinez
– Eric Martinez, Commented Jun 12, 2015 at 22:09
are you sure it is not already running in the background on port 3306. look at task mgr / services / MySQL56 — Drew
– Drew, Commented Jun 12, 2015 at 22:10
just use a pack like xampp or something to install it. Much easier than installing configuring yourself. also note that you need a space between -u and root — RisingSun
– RisingSun, Commented Jun 12, 2015 at 22:13

BK435 · Accepted Answer · 2015-06-12 22:44:00Z

7

You need to place mysql in your environment variable PATH in order to run it from the command prompt, if you are not in bin directory of mysql.

On windows 7 (should be similar for 8):

go to control panel>system
on left hand side you should see Advanced system settings>double click on that
At bottom of system properties you should see Environment Variables
scroll down in the bottom panel till you see PATH click on it
then click EDIT button underneath>opens new window Edit system variables
at the end add your path to your mysql installation bin folder like C:\mysql\mysql5.6.23\bin; (must separate by ;).

enter image description here

answered Jun 12, 2015 at 22:38

BK435

3,1863 gold badges22 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1