[Watford] MySQL - Help

[Walt]

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?

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 17:15
To: watford at mailman.lug.org.uk
Subject: Re: [Watford] MySQL - Help

On Wed, Feb 27, 2008 at 05:01:01PM -0000, Walt wrote:
> Hi Everyone,
> 
> I have mucked up my MySQL server.  I removed (by mistake) the root user
for
> admin purposes using MySQL WebAdmin and I cannot now access any of my
> databases now. All I get is 'access denied'.
> 
> So I really do need some guidance.  If I have learned anything in Linux
then
> its that there is always a file somewhere that can be edited to rectify a
> problem such as this. I have checked the MySQL website but its too
technical
> for me. I have tried the MySQL command line tool but there is no command
(as
> far as I can tell) to setup new privileges with user and password.

Close the database server.
The database tables are prob kept in a directory like /var/lib/mysql
(depends on what distro you run).

There is one directory per database, the database that interests you
is the mysql one. In there the 'user' table is where root's details were
kept.
Restore from backup the files user.MYD and user.MYI and user.frm
Restart the database server and you should be back in business.

-- 
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