mysql is not an internal command error solution

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

Solution:

Open the computer's environment variables, select system variables, open Path, and add the mysql bin directory path.

Here is an example:

Before adding environment variables

Add environment variables

After adding the environment variables, restart mysql

Content extension:

I used to use visual tools to call the database, but today I suddenly found out using the command line:

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

After some trouble, I found what was wrong and shared it with you.

Note 1: First check whether the environment variable has 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 create a new MySQL installation path/bin path, for example, mine is C:\Program Files\MySQL\MySQL Server 5.5\bin , just add it in. Finally, make sure to remember to add the bin directory. I didn’t write this, I only added the installation directory, so I couldn’t find it.

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

The commonly used command line opening method is window key + R key, but this is not run as an administrator

How to open the command line as an administrator:

Method 1: Right-click the window in the lower right corner of the computer -----> Search

Method 2: Right-click the window in the lower right corner of the computer -----> Window PowerShell (Administrator)

After that, enter mysql -u account -p password, and the following will appear.

The above is the detailed solution to the error "mysql is not an internal command". For more information on how to deal with the error "mysql is not an internal command", please pay attention to other related articles on 123WORDPRESS.COM!