Database Startup
Steven Stern
subscribed-lists at sterndata.com
Thu Mar 25 16:10:26 UTC 2004
On Thu, 25 Mar 2004 11:02:04 -0500, "George Lemos" <listreader at lemosnet.com>
wrote:
>
>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 >
/root/sql-backup/all_databases_$test2.sql.gz
The files contain everything needed to recreate the databases.
--
Steve
More information about the fedora-list
mailing list