Topic: mysql diaster

[Allan Bergmann Jensen]

I have a serius problem with my MySql db on a e-smith server v.5.2:
I was changing users and passwords with the PhpMyAdmin module, which I have added on the server. Unfortunately I deleted the mysql-root-user by accident.

I have stopped the mysql server using:  
$ ps ax | grep mysql
and then killing all processes listed.

Then I try to restart the server using the safe option:
$ safe_mysqld --skip-grant-tables

This will not succeed - the process of starting the server never ends.

I know for sure that my databases still exist - some applications still work, and all the datafiles can be found in /var/lib/mysql/.

I guess that the reason that the procedure described here won't work, has something to do with e-smiths templates. But I'm almost a newbie regarding Linux, and I can't figure out how to make it all work again.

Can anybody help me?

Regards,
Allan Bergmann Jensen

[Allan Bergmann Jensen]

I a lucky man.
The problem is solved. One of the mysql-users still working on the MySql database, were granted ALL privileges. From there I have been able to restore my previus settings.

Sorry to have trubled you.
Allan