How to set mysql environment variables

How to set the environment variables of mysql: 1. Click [Computer], [System Properties], [Advanced System Settings], [Environment Variables]; 2. Edit the PATH variable and add the bin directory path; 3. , open the command prompt and test whether the setting is successful.

Specific method:

(Recommended tutorial: mysql video tutorial)

First click on Computer--System Properties--Advanced System Settings--Environment Variables.

Then find the path in the system variable, click Edit, then copy the path of the bin directory under the mysql installation directory to the path, and click OK.

Finally check whether the environment variable is set successfully.

Open the command prompt and directly enter mysql -uroot -proot123456 (Note: u is the abbreviation of user, which is the user; p is the abbreviation of password, which is the password; so you should write the password you set after p), The following results indicate that the configuration is successful and you can log in successfully in any directory.

Related recommendations: mysql tutorial

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