Hi,

i have been trying to install MySQL on my companies system for some time now and have not been successful

I have tried installing various different versions and it seems its all a little messy, ive tried to remove MySQL the best i can by doing a "whereis mysql" and then using "rm -rf" to remove them accordingly.

When i try installing MySQL, it says MySQL may currently be running because the port is in use. I've also ran "grep mysql /etc/services" and it has listed the 2 MySQL services on 3306, udp and tcp.


If someone could help me to completely remove MySQL (Services etc) and then a step-by-step guide of how to install it again that would be great and would be really appreciated.


Thanks in advance,
Michael

How did you install it, with your distro's packaging system or manually from a source tarball? If the former, then your package manager should have a command to uninstall it; if the latter (via 'make install'), then there should be some sort of 'make uninstall' syntax - check the makefile.

Hi,

It wont uninstall properly because i removed certain files. I believe everything is removed now, however the services still seem to be running and when i try to stop them it i get an error, something about a PID file.

Is there anyway of forcing services to end or something ?


p.s. i installed it via a tar archive


Kind Regards,
Michael

You can kill a service by sending the process a kill signal, e.g. 'kill pid', or 'kill -9 pid' if that doesn't work.

Hi,

It's not a process, its a service

Im not too good at linux, only know the basics


Kind Regards,
Michael

Using rm -rf may actually have caused more problems because it appears like you did not remove the whole installation by doing that. Anyway how did you install it and what distribution are you using. Also what files did you remove? Its best to provide as much info as possible in your initial post to help others know exactly what your problem is.

In linux, services are either processes or started by inetd. Do 'ps ax | grep sql' and see if there's any sql process running. If there is, kill it as above; if not then it's started by inetd, and you need to comment out the line in inetd.conf (I forget exactly what that file is called) and then send inetd SIGHUP to tell it to reread its configuration file.

Hi,

I just removed the /bin/mysql and the /sbin/mysql
I dont know much about my companies distro etc, however i believe its Red Hat because i can use RPM (never used it without errors hehe).

Sorry for not being able to provide everything, but if you could provide me with a list of things to try, then that would be great too.

Kind Regards,
Michael

Many distros use RPM (although RH originally designed it). If you installed via 'rpm xxxx' then read the rpm docs to see how to uninstall it. Did you try the ps command I suggested earlier?

Hi,

yeah i tried the ps command however it just returns "ps" and "bash".

i didnt use the rpm method of installation, just used the manual method (untarring it, make install etc)


Kind Regards,
Michael

If ps only returns ps and bash, you probably didn't type 'ps ax'.
If you installed via 'make install', look in the makefile for an 'uninstall' target.

Any software installed via rpm should be uninstalled using rpm. Deleting essential individual files will cause you problems when it comes to uninstalling the whole package (this is because the mysql stuff is installed into various directories even though its shipped in one or two packages). Anyway, what are the results of running
You can also find out what distro you are using by doing

hi,

There is nothing in the "ps ax" list relating to the MySQL Server



kind regards,
Michael

Hi,

i tried that command to find out the version but i got a permission denied error, even though i am logged in as root.


Kind Regards,
Michael

Hi,

also the "rpm -qa | grep -i mysql" command returns the following:

[root /root]# rpm -qa | grep -i mysql
MySQL-Max-3.23.38-1


kind regards,
Michael