Re: [cobalt-users] Major MySQL problem

["Steve Werby" <steve-lists@xxxxxxxxxxxx>]

"Mark Carruth" <mcarruth@xxxxxxxxxx> wrote:
> Some idiot has removed the "mysql" database from my mysql server, meaning
> that it has no logged users and I can no longer log in as root.
>
> Is there a way to manually edit a user file? Or to reset MySQLs config ?

I believe you can rerun scripts/mysql_install_db from within the MySQL
source tree.  If you don't have the source tree on the server then download
it from mysql.com.  If the "idiot" is not another server admin, please learn
more about the MySQL privilege system so you don't create users with
privileges to modify the mysql database.  Also, if you have backups just
restore those for the db.  If not, it's probably time to start running
backups using mysqldump (program included in mysql source distribution)
which creates dump files consisting of SQL statements which can be used to
recreate database by simply doing:

mysql < dumpfile

--
Steve Werby
President, Befriend Internet Services LLC
http://www.befriend.com/