Re: [cobalt-users] Deinstall Mysql & re-install

[Hendrik Runte <cobalt@xxxxxxxxxx>]

Hi Gilles,

to access some (or all) of your MySQL dbs without logging in using MySQL Monitor it is possible to start mysqld without any login information providing you have root rights.

So, [su] to become root.
Terminate any MySQL services running on your machine. See [top] for PIDs in case you cannot terminate MySQL using MySQL Monitor by using [kill]. Hard problems with MySQL seem to need [kill -9].

Now it\'s time to start your db server with [mysqld --skip-grant-tables]. Now you can login with \'root\' without password. Now alter any wrong passwords. After fixing your problems, disconnect to MySQL server and terminate its services.

Restart MySQL by using [safe_mysqld].

Good Luck!


Hendrik Runte
--
granus.net

Zitiere Gilles Dumangin <gilles_dumangin@xxxxxxxxxxx>:

> I have lost access to some Mysql database after a reinstall.
> 
> Is there a way to get back in? like deleting the mysql database (the one
> 
> that holds privileges?)
> 
> Thanks for your help.
> 
> Gilles
> 
> 
> _________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at
> http://www.hotmail.com.
> 
> _______________________________________________
> cobalt-users mailing list
> cobalt-users@xxxxxxxxxxxxxxx
> To Subscribe or Unsubscribe, please go to:
> http://list.cobalt.com/mailman/listinfo/cobalt-users
>