Nick,
There is (at least) one other way of doing this.
1. Shutdown myql
2. Go grab a copy of one of the unix binary downloads.
3. Go into your data directory, rename the directory called mysql to
mysql_bak or something equally original.
4. Untar the binary distribution in some safe location, grab the mysql
directory from this new data directory, and copy it to your server's data
directory. Make sure you have done step 3 first!
5. Make sure you have the permission right on the "new" mysql directory &
its contents.
6. Restart mysql, and you should be able to log in as root from the
localhost with no password.
7. Use mysql_bak and modify the password for root to what you want it to
be.
8. Shutdown mysql.
9. Remove the "new" mysql directory and COPY the mysql_bak directory to
mysql, check permissions, and restart mysql.
10. Smile as you log back in with the root password and all of your other
accounts are unaffected.
Scott Helms
----- Original Message -----
From: "Nick Wilson" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, April 30, 2002 1:32 PM
Subject: Re: lost root password trouble
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
>
> * and then James Carrier declared....
> > It'll be something like:
> >
> > /usr/bin/safe_mysqld --defaults-file=/etc/my.cnf --skip-grant-tables
>
> Well, that's certainly progress of sorts :-)
> It's just 'hanging' now. It says 'starting mysqld daemon with databases
> from /var/lib/mysql' and just hangs....
>
> any ideas?
>
> thanks james..
> - --
> Nick Wilson // www.explodingnet.com
>
>
>
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.0.6 (GNU/Linux)
>
> iD8DBQE8ztUxHpvrrTa6L5oRAlCrAKC3HOrhNL2XkeUB68EHuYExKzPMIQCdGdji
> khY4FsLiU4JeTj03OJzjNKw=
> =1fV6
> -----END PGP SIGNATURE-----
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
