Install and uninstall mysql service under windows_PHP tutorial

Install and uninstall mysql service

Install mysql service

Create and edit a bat file with the following content, and execute it (e:mysql inmysqld-nt. exe is the installation directory, fill in the actual situation)

@ECHO OFF

e:mysql inmysqld-nt.exe -install

net start mysql

Uninstall the mysql service

Create and edit a bat file with the following content to execute it (e:mysql inmysqld-nt.exe is the installation directory, according to the actual situation Fill in)

@ECHO OFF

net stop mysql

c:mysql inmysqld-nt.exe -remove

------------------------------------------ -----

The problem that MYSQL cannot be started. The specific symptoms are as follows: No matter whether you double-click mysqld.exe directly or open the command prompt, there is no response. (XP system)

Then try Control Panel >>> Management Tools >>> Services >>> mysql method to start, a prompt box pops up and the process terminates unexpectedly. I am depressed...

I had to uninstall mysql and reinstall it, but found that the problem was not solved. I asked others for advice and got tips on reinstalling the system. I started to go crazy...

Well, the painful memories are here, now let’s talk about how to solve it.

The first thing is to uninstall the mysql service, otherwise it will be considered as uninstalling mysql There is still the mysql item in the program and service, so the problem cannot be solved. Assume that my mysql is installed in C:MYSQL, and run mysqld-nt -remove (with a space in the middle) under the command prompt c:mysql in, and it will prompt to uninstall. Successfully. Then uninstall mysql in Control Panel >>> Add or Remove Programs, then restart, install mysql and run mysqld.exe (mysqld-nt.exe under win2000), the command prompt box flashes by, like this You can now see the mysql process in the task manager, which means your mysql is resurrected: )