WampServer Fixing conflicting MYSQL Issues

From TNG_Wiki
Jump to navigation Jump to search

Fixing conflicting MYSQL Issues

You are here because it has been determined that there are two versions of MYSQL running on the PC one of which is installed with WAMP Server. This causes the MYSQL service on WAMP server to not start so the WAMP panel icon looks like:

Partially Running

WampServer 2.2 WampServer 2.0c
2.2 Not all services are running 2.0c Not all services are running

The red and yellow status colors mean that WAMP server is not running or is only partially running.

There are three ways to fix this issue

Stop the Service

Stop the MYSQL service that conflicts with WAMP MYSQL - Less catastrophic than removing the one version of MYSQL - Data is recoverable

See: WampServer modify service

Change the port number

Change the port setting of one of the MYSQL service(s) - The most transparent - Both databases reside and work - downside is that more memory is used.

See: WampServer MYSQL port changes

Remove the program

Remove (delete the whole program) the MYSQL that existed before WAMP server was installed - There may be data stored in the MYSQL database - Loss of data probable. If you are not sure why there is another MYSQL program installed and running, this step may not be the best solution and should be considered the last resort. Before removing try to determine why this MYSQL program is installed.

See: WampServer Remove Program

Related Links