Koozali.org: home of the SME Server
Legacy Forums => General Discussion (Legacy) => Topic started by: Allan Bergmann Jensen on December 09, 2002, 12:56:02 AM
-
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
-
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