RE: [cobalt-users] Mysql: Root's rights are gone

["Robert Roose" <robertr@xxxxxxxxxxxxx>]

yipe :)

I thought about that one :)

can you create a new dbase and import the mysql dbase in that one.. 
after that go to: /var/lib/mysql/

type mv mysql mysql.old ; mv newdb mysql

that could work.

i think :)

> -----Oorspronkelijk bericht-----
> Van: Maurice de Laat [mailto:muisnetw@xxxxxxxxx]
> Verzonden: woensdag 28 mei 2003 17:26
> Aan: cobalt-users@xxxxxxxxxxxxxxx
> Onderwerp: Re: [cobalt-users] Mysql: Root's rights are gone
> 
> 
> 
> On Wed, May 28, 2003 at 04:12:51PM +0100, Ian wrote:
> 
> > You do not have to restore all the databases, just the 'mysql' 
> > database.
> > 
> > This contains all the usernames / passwords / hosts / permissions 
> > etc.
> 
> Robert & Ian,
> 
> Thanks for your very quick reply.
> 
> If I try to restore the mysql database, I get the following error:
> ERROR 1044 at line 11: Access denied for user: 
> 'root@localhost' to database
> 'mysql'
> 
> So... It looks to me like: in order to restore the 
> permissions, I need the
> permission ?!
> -- 
> Maurice de Laat
> 
> _____________________________________
> cobalt-users mailing list
> cobalt-users@xxxxxxxxxxxxxxx
> To subscribe/unsubscribe, or to SEARCH THE ARCHIVES, go to:
> http://list.cobalt.com/mailman/listinfo/cobalt-users
>