8,693 views ![Share: [Solved] MySQL is not recognized as an internal or external command](https://maheshwaghmare.com/wp-content/plugins/easy-social-shares/assets/images/facebook.svg "Share: [Solved] MySQL is not recognized as an internal or external command")
![Share: [Solved] MySQL is not recognized as an internal or external command](https://maheshwaghmare.com/wp-content/plugins/easy-social-shares/assets/images/twitter.svg "Share: [Solved] MySQL is not recognized as an internal or external command")
Are you encountering the frustrating error message MySQL is not recognized as an internal or external command, operable program, or batch file?
Don’t worry; we’ve got you covered with a solution to resolve this issue and get your MySQL running smoothly.
You may sometimes see the error:
‘mysql’ is not recognized as an internal or external command, operable program, or batch file.
Something as in the below screenshot:
![[Solved] MySQL is not recognized as an internal or external command 1](https://maheshwaghmare.com/wp-content/uploads/2022/10/mysql-is-not-recognized-as-an-internal-or-external-command-operable-program-or-batch-file-1024x593.png "[Solved] MySQL is not recognized as an internal or external command 1")
Here, The issue is the mysql.exe is not set up on your Windows Operating System.
‘mysql’ is not recognized as an internal or external command,
operable program, or batch file.
![[Solved] MySQL is not recognized as an internal or external command 2](http://maheshwaghmare.com/wp-content/uploads/2024/03/kinsta-728x90-wp-light-2-months-free-hosting.jpg "[Solved] MySQL is not recognized as an internal or external command 2")
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:
![[Solved] MySQL is not recognized as an internal or external command 3](https://maheshwaghmare.com/wp-content/uploads/2021/05/php-not-a-internal-or-external-command.png "[Solved] MySQL is not recognized as an internal or external command 3")
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 below
![[Solved] MySQL is not recognized as an internal or external command 4](https://maheshwaghmare.com/wp-content/uploads/2021/05/add-environment-variables.png "[Solved] MySQL is not recognized as an internal or external command 4")
![[Solved] MySQL is not recognized as an internal or external command 5](http://maheshwaghmare.com/wp-content/uploads/2024/03/kinsta-728x90-dark-speed-boost.jpg "[Solved] MySQL is not recognized as an internal or external command 5")
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, 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.
![[Solved] MySQL is not recognized as an internal or external command 6](https://maheshwaghmare.com/wp-content/uploads/2021/05/add-new-path-screen.png "[Solved] MySQL is not recognized as an internal or external command 6")
Step 3: Add MySQL.exe File Path Step 3: Add MySQL.exe File Path
I have an Xampp, but somehow the environment variable is not working.
You may have a different place for the mysql.exe file.
You need to find it and set it in the Environment Variable Path as below:
![[Solved] MySQL is not recognized as an internal or external command 8](https://maheshwaghmare.com/wp-content/uploads/2022/10/the-xampp-mysql-directory-1024x550.png "[Solved] MySQL is not recognized as an internal or external command 8")
Here, My mysql.exe file exists in the C:\xampp\mysql\bin directory.
So, I’m adding this path as:
![[Solved] MySQL is not recognized as an internal or external command 9](https://maheshwaghmare.com/wp-content/uploads/2022/10/add-mysql-path-in-system-properties-advanced.png "[Solved] MySQL is not recognized as an internal or external command 9")
That’s it.
![[Solved] MySQL is not recognized as an internal or external command 10](http://maheshwaghmare.com/wp-content/uploads/2024/03/kinsta-728x90-dark-2-months-free-hosting.jpg "[Solved] MySQL is not recognized as an internal or external command 10")
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.
![[Solved] MySQL is not recognized as an internal or external command 11](https://maheshwaghmare.com/wp-content/uploads/2022/10/mysql-version-latest-check-1024x593.png "[Solved] MySQL is not recognized as an internal or external command 11")
![[Solved] MySQL is not recognized as an internal or external command 12](http://maheshwaghmare.com/wp-content/uploads/2024/03/kinsta-728x90-light-general.jpg "[Solved] MySQL is not recognized as an internal or external command 12")
Frequently Asked Questions Frequently Asked Questions
What does the error “MySQL is not recognized as an internal or external command” mean? What does the error “MySQL is not recognized as an internal or external command” mean?
This error message typically means that your system is unable to find the MySQL executable file. This can occur for several reasons, such as if MySQL is not properly installed or if its installation directory is not added to the system’s PATH environment variable.
How can I check if MySQL is properly installed on my system? How can I check if MySQL is properly installed on my system?
You can check if MySQL is installed by running the following command in the command prompt:
mysql -u root -p
This command will attempt to connect to the MySQL server using the root user and prompt you for a password. If MySQL is properly installed, you should be able to access the MySQL prompt.
You may also like similar articles You may also like similar articles
Below are some articles which are similar to the above.
Read more MySQL articles Read more MySQL articles
Also, see some other MySQL how-to articles:
- (Solved) mysqld exe aria recovery failed
- Check if MySQL is Running
- How to Check MySQL Version in Windows
- Importance of databases
- Install MySQL on Windows
- Introduction to Databases
- [Solved] ERROR 2002 (HY000): Can't connect to MySQL server on 'localhost' (10061)
- [Solved] MySQL is not recognized as an internal or external command