[Solved] MySQL is not recognized as an internal or external command

You may see sometimes the error: ‘mysql’ is not recognized as an internal or external command, operable program or batch file.

Something as in the below screenshot:

Here, The issue is the mysql.exe is not set up on your Windows Operating System.

You just need to follow the below simple steps to execute the MySQL command on the terminal/CMD.

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

MySQL is not recognized as an internal or external command.

We know that MySQL is a server-side scripting language.

But, Most of the time we face an issue:

Follow the below steps to solve the MySQL is not an internal or external command

#Step 1: Open System Properties Step 1: Open System Properties

• Click on the Start menu from Windows Operating System
• Search for Environment Variables
• Then click on Environment Variables

You will see something as below

Struggling with downtime and WordPress problems? Kinsta is the hosting solution designed to save you time! Check out our features

Top ↑

#Step 2: Add System Variables Step 2: Add System Variables

You add the MySQL file path in either the System variables or User Variables

• System variables – If we add a path in system variables then other system users also use MySQL through the command line.
• User variables – If we set the path for the current user then only the current user can execute the MySQL through the command line.

You can add the PATH as per your requirement.

Deploy your application to Kinsta – Start with a $20 Credit now. Deploy now and get $20 off

Top ↑

#Step 3: Add MySQL.exe File Path Step 3: Add MySQL.exe File Path

I have a Xampp, but somehow the environment variable not working.

You may have a different place for the mysql.exe file.

You need to find it and set it in Environment Variable Path as below:

Here, My mysql.exe file exists in the C:\xampp\mysql\bin directory.

So, I’m adding this path as:

That’s it.

Top ↑

#Done! MySQL is working now Done! MySQL is working now

To confirm that MySQL is now working just execute the below command:

mysql --version

E.g.

You may also like:

• “PHP” is not recognized as an internal or external command