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

What is very troublesome is that Apache starts normally, but MySql cannot start, and what is said on Baidu is not very useful (the predecessor of the final solution is still Baidu). Most of them are talking about port problems on Baidu. Apache is 80Jing MySQL is 3306, but it is safe to detect the information occupied by the port, that is to say, the port is not fatal.

I said that the situation I encountered:

1. There is no MySql (or MySqla) in the registry

two。 Uninstall the php toolkit and completely delete the mysql database, including the registry, but the truth is always cruel

3. Open the service and failed to start the mysql service (the path specified by the system cannot be found)! This one is the most embarrassing.

That's about all the problems. Talk about the solution:

1. Uninstall the mysql database completely and delete it cleanly, including the registry. (ignored when installing the database for the first time)

1)。 Uninstall and delete the installed package

2)。 Delete the registry

Win+R enter regedit to open the registry-> HKEY_LOCAL_MACHINE\ SYSTEM\ ControlSet001\ services\ MySQLa

HKEY_LOCAL_MACHINE\ SYSTEM\ ControlSet002\ services\ MySQLa

Delete MySQLa (if MySQL is also deleted)

3)。 Delete C:\ ProgramData\ MySQL (delete the MySQL folder). If you don't delete it, it will be very difficult to open cmd and enter sc delete mysql. Access will be denied. Screenshots cannot be taken here.

ProgramData is generally hidden, it can be displayed, display method:

Go to disk C, tools-> folder options-> View-> Show hidden files, folders and drives

4)。 Use the administrator to open the command prompt and delete the remaining files (if not executed, it will not work on the installation, so this is very important)

two。 Install the php toolkit to see if it can be started (try to see if it is successful, do not continue successfully, successfully jump to 6)

3.win+r enter cmd,cd to the bin directory of the mysql installation path, such as my path:

4. You can delete the contents of the registry again to indicate that the deletion was successful (prompt is successful)

5. Delete, of course, we have to install, (deletion and installation is aimed at the mysql in the service can not find the path, can find no need to perform operations, of course, if there is no other way to start up, you can also give it a try, anyway, you can't start around, why not try it? )

Execute the installation command on the path you just took:

C:\ windows\ system32 > mysql-install (hint: copy and paste directly)

6. When we open the service, we will find that there is not only MySql but also a MySqla in the service. We start MySqla instead of MySql (mysql is the one that didn't exist last time, so we don't care). After starting the service, start the php toolbox to see if it is successful.

If successful, check to see if there is a MySQLa in the registry, and if so, type mysql-uroot-p in the cmd to see if you can log in to the database.

If the prompt mysql is not an internal command, we put the bin path under the path of the user variable

Perfect. All the problems have been solved. Thank you for reading it carefully, if you have any questions, you can also leave a message directly, or send me an email: 1760909338#qq.com, please change # into @ symbol, thank you.

Finally, good luck.

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.