Database Startup

Steven Stern subscribed-lists at
Thu Mar 25 16:10:26 UTC 2004

On Thu, 25 Mar 2004 11:02:04 -0500, "George Lemos" <listreader at>

>I am making progress, I have phpadmin in now, but had to yum php-mysql in
>order to get it started. H
>However I think something got muddled yesterday while I was wrestling with
>mysql trying to get the root password added for the localhost and host. No
>password I normally use for box testing seems to be working. What's the
>recommended solution to reset the DB root level passwords? Do I need to
>reinstall one or all of the packages?

There are probably more elegant solutions, but I lost the root passwords when
I was first learning MySQL.  Since I had no real data there, renamed the mysql
directory holding the tables to mysql.old and restarted mysql. I then started
over with a fresh DB.  

Backup is a good thing!  I have a cron job that runs every night and backs up
all my dbs:

  0 0 * * * export test2;declare test2=`date|cut -c 1-3`;mysqldump
--all-databases -prootpasswordhere |gzip >

The files contain everything needed to recreate the databases.


More information about the users mailing list