How to handle MySQL startup errors

MySQL is an open-source small-scale database that is very popular. In the process of continuous improvement, MySQL has stored procedures, views, functions, and other functions, and now supports subqueries, in some cases, large data volume queries exceed some large databases, so more and more projects begin to use MySQL. However, because MySQL is small and flexible, it often encounters some difficulties in the deployment process. I will list some of the problems and solutions I have encountered for my colleagues' reference, you are also welcome to share with me the issues you have encountered and solutions.

1. The installation version cannot be started.

After installation, you can find the my. ini file in the installation directory and find Port = 3306. Modify the port and restart the MySQL service;

 

2. The green version cannot be started.

The green version is what we often call the uninstalled version. The MySQL installation directory can be completely copied to another machine without installation. For how to use the green version, see other articles, here only the solution that cannot be started is described. For port occupation, refer to 1. Note that if it is the installation version of another copied machine, you also need to modify the local file, which is also the my. ini file. Find the following two lines:

Basedir = "D:/MySQL Server 5.0"

Datadir = "D:/MySQL Server 5.0/data /"

And modify it to the directory corresponding to your local MySQL. Here, basedir is the MySQL installation directory, and datadir is the place where the MySQL data structure is stored. It must correspond to the local machine. Otherwise, the corresponding file cannot be found when the MySQL service is started.

 

The above are the problems I encountered during use. You are welcome to add them.