How to configure environment variables in mysql in win10

I don’t know if you know how to configure the environment variables required by mysql in the win10 system. Today I will take you to know about it. Friends who need it can refer to it.

1. After installing mysql, you need to configure environment variables (win 10)

Select "My Computer", right-click and select "Properties" ->Advanced-> System variables in environment variables, set the following corresponding values ​​for the two system variables MYSQL_HOME and Path (setting principle: If there is a corresponding variable, edit the variable directly, be careful not to add only Delete; if the variable does not exist, create it and then edit it.)

Since there is no environment variable here, create a new environment variable MYSQL_HOME

MYSQL_HOME=D:\App\Mysql (Choose your own installation directory for the directory)

(Note here that if you are adding variable content to an existing variable, Before entering the variable content, you must first enter the semicolon in the English input method)

2. After creating the new environment variable, find Path in the environment variable, click Edit, and Click New in the pop-up box and create a new environment variable

Path=%MYSQL_HOME%\bin (Add %MYSQL_HOME%\bin under the Path path)

3. Enter %MYSQL_HOME%\bin, then click OK, remember there must be 3 OKs

If you click Edit Path, the opening will look like this

You need to add ;%MYSQL_HOME%\bin at the end of the variable value ( MYSQL_HOME%\bin is preceded by a semicolon in English)

After the editing is completed, confirm that the configuration is complete

After the configuration is completed, we can enter

mysql -u root -p

in cmd Enter the password after pressing Enter

Related recommendations: "mysql tutorial"

The above is the detailed content of How to configure environment variables in mysql in win10. For more information, please follow other related articles on the PHP Chinese website!