Arch Linux

timm

Member

From: Wisconsin

Registered: 2004-02-25

Posts: 417

How to completely remove mysql [underlying issue solved]

I am setting up a new system with egroupware.  Mysql started doing weird things, so I decided to remove it and reinstall it.  However, I cannot figure out how to get everything (databases, everything) off the system.

When I run pacman -R mysql, I get the normal removal line, then one that says

error: command failed to execute correctly

the pacman.log file contains no errors

I tried pacman -Rd mysql, with no change

What do I need to do to get a system where mysql appears to never have been installed?

Last edited by timm (2009-11-19 03:07:00)

ozar

Member

From: USA

Registered: 2005-02-18

Posts: 1,686

Re: How to completely remove mysql [underlying issue solved]

The answer for fixing this error has been posted here:

http://bbs.archlinux.org/viewtopic.php?id=85054

---

oz

timm

Member

From: Wisconsin

Registered: 2004-02-25

Posts: 417

Re: How to completely remove mysql [underlying issue solved]

I tried both

pacman -Rd mysql followed by pacman -S mysql

and the long form fix as well.  Neither fixes this problem.

Last edited by timm (2009-11-18 21:45:25)

ilpianista

Fellow developer

Registered: 2007-10-06

Posts: 568

Website

Re: How to completely remove mysql [underlying issue solved]

# groupadd -g 89 mysql
# useradd -u 89 -g mysql -d /var/lib/mysql -s /bin/false mysql

timm

Member

From: Wisconsin

Registered: 2004-02-25

Posts: 417

Re: How to completely remove mysql [underlying issue solved]

I login as user1, su to root

[root@server user1]# groupadd -g 89 mysql
groupadd: group 'mysql' already exists
[root@server user1]# useradd -u 89 -g mysql -d /var/lib/mysql -s /bin/false mysql
useradd: user 'mysql' already exists
[root@server user1]# userdel mysql
userdel: user mysql is currently logged in
[root@server user1]# w
17:09:25 up  2:48,  2 users,  load average: 0.04, 0.01, 0.00
USER     TTY        LOGIN@   IDLE   JCPU   PCPU WHAT
user1     tty1      14:24    1:18m  7.61s  0.02s -bash
user1     pts/0     17:02    0.00s  0.02s  0.03s sshd: user1 [priv]
[root@server user1]#

Ok, I'm over my head.  Will reboot and try it again......

[update]
reboot allowed me to delete user mysql and group mysql, but on reinstallation after running the recommended commands, the error on removal persists.  Reinstalled and I'll try to recreate the database.

[update]
Never did figure out how to get rid of mysql, but the error did end up being the default socket location.  The errors egroupware was throwing did not appear to implicate that, but going back step-by-step with the correction got it (mostly) working.

Last edited by timm (2009-11-19 03:06:38)