Shulou(Shulou.com)06/01 Report--

Fix the problem that mysql is not an internal command error? This problem may be often seen in our daily study or work. I hope you can gain a lot from this question. The following is the reference content that the editor brings to you, let's take a look at it!

The error that mysql is not an internal command occurs because the bin directory path of mysql is not added to the environment variable

Solution:

Open the computer's environment variable, select the system variable, open Path, and add the bin directory path of mysql to it.

Examples are as follows:

Before adding an environment variable

Add environment variabl

After adding the environment variable, restart mysql

Content extension:

It used to be to use visualization tools to call the database, but today I suddenly found out with the command line:

Mysql' is not an internal or external command, nor is it a runnable program or batch file.

After a lot of trouble, I found out what was wrong. I'll share it with you.

Note 1: first see if the environment variables have been added to the path

My computer-> right-click-> Properties-> Advanced system Settings-> Advanced-> Environment variables-> OK-> system variables (S)-> Path (then double-click)

Then add the mysql installation path / bin path to the new project, for example, mine is C:\ Program Files\ MySQL\ MySQL Server 5.5\ bin, and finally confirm

Remember to add the bin directory. I just didn't write this, only the installation directory, so I can't find it all the time.

Note 2: be sure to run the command line as an administrator

The common way to open the command line is window + R key, but this is not run as an administrator

How to open the command line as an administrator:

Method 1: the window window in the lower right corner of the computer, and then right-> search

Method 2: the window window in the lower right corner of the computer, and then right-> Window PowerShell (administrator)

After entering, enter the mysql-u account number-p password, appear below and it will be done.

Thank you for reading! After reading the above, do you have a general understanding of solving the problem that mysql is not an internal command error? I hope the content of the article will be helpful to all of you. If you want to know more about the relevant articles, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.