Hi all, I just joined list. I spent a couple hours in the archive and
decided MySQL better improve their install message regarding setting the
root password! Half the posts are about it going badly. ;)
I believe I found the answer in the archives, but they all aren't the same
answer. So is the concensus for resetting the root password, whether it was
set or not the following?
If it is, add it to your binaries! (I'm actually quite friendly and patient
:)
root# ./bin/safe_mysqld --user=mysql --skip-grant-tables &
root# ./bin/mysql -u root -p
Enter password: (hit return at this point)
> UPDATE user SET Password=PASSWORD("desiredpasswordhere") WHERE
User="root";
> Exit
root# ./bin/mysqladmin flush-privileges
root# ./bin/mysql -u root -p
Enter password: desiredpasswordhere
---------------------------------------------------------------------
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
