What should I do if mysql installation cannot be opened?

The solution to the problem that mysql installation cannot be opened: first right-click "Computer"; then in the pop-up "System Properties" interface, click "Environment Variables"; then select path and add it to path The installation path of mysql; finally click "OK" to save.

Recommended: "mysql video tutorial"

Add the mysql installation path.

First right-click "My Computer (wind7 is "Computer")"--->"Properties"-->"Advanced System Settings", the "System Properties" interface will pop up

Click "Environment Variables" to pop up the "Environment Variables" window, as shown in the figure

Find "Path" under "System Variables", select path, click Edit, and add the installation path of mysql to the path. Mine is D:\Program Files\MySQL\MySQL Server 5.1\bin, so add the path D:\Program Files\MySQL\MySQL Server 5.1\bin at the end of the path. Finally "OK" to save.

Sometimes mysql does not have permission to read the import drive letter you specify. At this time, we open the DOS command window, find "Run" and type the "cmd" command

When mysql does not have permission to read the permissions of the import drive letter you specify, we put the sql file in the temp directory (Linux is in / tmp, windows is in c:/windows/temp), this directory can be read by all users by default.

Finally open the DOS window and type mysql installation path>mysql -u username -p password to start mysql. Then type the command mysql>source drive letter:\imported database name.sql to import the mysql database.

The above is the detailed content of What should I do if mysql installation cannot be opened?. For more information, please follow other related articles on the PHP Chinese website!