<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Nick Morrott wrote:
<blockquote
cite="mid5387cd30703121040g42d2812eod98147206a3d0a33@mail.gmail.com"
type="cite">
<pre wrap="">On 12/03/07, Damian Surr <a class="moz-txt-link-rfc2396E" href="mailto:damian@gingermagic.co.uk"><damian@gingermagic.co.uk></a> wrote:
</pre>
<blockquote type="cite">
<pre wrap=""> Nick Morrott wrote:
On 12/03/07, Damian Surr <a class="moz-txt-link-rfc2396E" href="mailto:damian@gingermagic.co.uk"><damian@gingermagic.co.uk></a> 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?
</pre>
</blockquote>
<pre wrap=""><!---->
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
</pre>
</blockquote>
<font face="Helvetica, Arial, sans-serif">Thanks Nick<br>
<br>
I've not had Mythtv up and running yet since a format and re-instal, so
there's nothing that needs backing up.<br>
<br>
I'll remove mysql-server and mythtv-database again, then do the<br>
</font>
<pre wrap=""># sudo rm -rf /var/lib/mysql/</pre>
<font face="Helvetica, Arial, sans-serif">thing, then reinstall </font><font
face="Helvetica, Arial, sans-serif">mysql-server and mythtv-database.
Hopefully that'll get me somewhere.<br>
<br>
Cheers<br>
Damian<br>
</font>
</body>
</html>