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

Editor to share with you the mysql installation can not open the solution, I believe that most people do not know much about it, so share this article for your reference, I hope you will learn a lot after reading this article, let's go to understand it!

Mysql installation can not open the solution: first right-click "computer"; then in the pop-up "system Properties" interface, click "Environment variables"; then select path, and add the installation path of mysql in path; finally, "OK" to save.

Add the mysql installation path.

First, right-click "my computer (wind7 is" computer ")-- >" Properties "-->" Advanced system Settings ", and pop up the" system Properties "interface.

Click Environment variables, and the Environment variables window pops up, as shown in the figure

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

Sometimes mysql does not have the permission to read the import letter you specify. Then we open the DOS command window and find "run" and type the "cmd" command.

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

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

The above are all the solutions that cannot be opened by mysql installation. Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, 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.