[mythtv-users] My MySql hell :-)
Nick Morrott
knowledgejunkie at gmail.com
Mon Mar 12 17:40:15 UTC 2007
On 12/03/07, Damian Surr <damian at gingermagic.co.uk> wrote:
>
> Nick Morrott wrote:
> On 12/03/07, Damian Surr <damian at gingermagic.co.uk> wrote:
>
>
> Thanks Peter,
>
> I'll try that out later. I wondered myself if the 'apt-get remove
> --purge packagename' just removed the program and not the files, leaving
> me with the same problem. I was dubious about deleting mysql manually
> though in case other things were depending on it. Uninstalling
> mysql-server with the package manager went ok, but when I thought about
> getting rid of other mysql parts, the program told me that there were
> lots of dependencies (like amock etc) and it looked like it was going to
> remove all of those if i clicked continue, so I didn't :-)
>
> MySQL stores its users/passwords/privilege information in the mysql
> database, located in /var/lib/mysql/mysql/. Removing this as Peter
> suggested should allow a fresh reinstall with back-to-default
> passwords.
>
> Nick
>
> Thanks you two. Between you that's given me the best hope for success I've
> had in a while. I'll try it later. If it doesn't work, I my be asking
> questions about new hardware because I'm close to attacking it all with a
> sledge hammer!
>
> I assume I use:
> sudo rm /var/lib/mysql/mysql/
> to delete that directory?
No - by default rm only removes files, not directories.
Assuming you have a backup of your mythconverg database, I would
remove the /var/lib/mysql directory and everything underneath it (be
careful):
# sudo rm -rf /var/lib/mysql/
Nick
--
MythTV Official wiki:
http://mythtv.org/wiki/
MythTV users list archive:
http://www.gossamer-threads.com/lists/mythtv/users
"An investment in knowledge always pays the best interest." - Benjamin Franklin
More information about the mythtv-users
mailing list