[Watford] MySQL - Help

[Walt]

Sorry forgot to say, the MySQL Version is: 5.0.45

I tried to start command and it told me after a while '[1]+ Done'.  Unfortunately, MySQL Admin sitll tells me access denied.

I will have to byte the bullet and start from scratch,  uninstall and re-install.  I am really surprised that there is no fix for this. AND I will backup the \var\lib\mysql directory in full.

BTW my distro is Suse 10.3.

Thanks for your help.
Walter

-----Original Message-----
From: watford-bounces at mailman.lug.org.uk [mailto:watford-bounces at mailman.lug.org.uk] On Behalf Of Alain Williams
Sent: 27 February 2008 20:05
To: watford at mailman.lug.org.uk
Subject: Re: [Watford] MySQL - Help

On Wed, Feb 27, 2008 at 05:39:04PM -0000, Walt wrote:
> Thanks Alain,  but I don’t have a backup.  I'm not that far advanced yet
> that I know how or what to backup in linux except documents I create and
> know where they are stored.
> 
> So is there any other way to rectify this?

Hmmm, normally one would start the server with:

	mysqld_safe --skip-grant-tables &

and connect:

	mysql -uroot

however, I suspect that that will not work.

Prob the best thing is to provide you with a new mysql table.
These tables are not machine type specific, so please tell us what version
of mysql you are running and we can mail you a new one (move the
old one sideways first). Alternatively you will be able to get them
from the package management system for your distribution.

-- 
Alain Williams
Linux Consultant - Mail systems, Web sites, Networking, Programmer, IT Lecturer.
+44 (0) 787 668 0256  http://www.phcomp.co.uk/
Parliament Hill Computers Ltd. Registration Information: http://www.phcomp.co.uk/contact.php
Chairman of UKUUG: http://www.ukuug.org/
#include <std_disclaimer.h>

_______________________________________________
Watford mailing list
Watford at mailman.lug.org.uk
https://mailman.lug.org.uk/mailman/listinfo/watford

No virus found in this incoming message.
Checked by AVG Free Edition. 
Version: 7.5.516 / Virus Database: 269.21.1/1301 - Release Date: 27/02/2008 08:35
 

No virus found in this outgoing message.
Checked by AVG Free Edition. 
Version: 7.5.516 / Virus Database: 269.21.1/1301 - Release Date: 27/02/2008 08:35