Open Tech Notes

MySQL Could not start on Apache Friends

Today, I setup security for  Apache Friends package on one of my CentOS (5.0 final) servers. After I followed the command:

./lampp security

setup password for the lampp demo web page
turn off access Mysql via the network

Then, the Mysql server could not start. Even I use command:

./lampp startmysql

it said

Mysql Starting and exit to command line.

(note: the apache friends package version is 1.63a)

So, I went to apachefriends.org to find the answer and unfortunately I did not find anything that can help. I decided to upgrade it to the latest version(1.63b) because this server is currently not in service. I don’t worry about the data lose. Upgrading was smooth, but it did not work too.

Anyway, the last result, I removed the whole folder /lampp from /opt and re-installed  apache friends version 1.63b. It worked fine.

One thing I need to remember: Don’t forget stop lampp before remove the folder /lampp, otherwise, it will waste a lot of time to kill some process manually.