Re: Root password revisited
At 17:44 28-8-01 -0700, Gregg Baker wrote: >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. ;) When installing from source you will get a messages telling you to set the root password (mysql_install_db does this) but it is NOT mentioned in the manual.txt I didn't see it in the online manual but I didn't look to long.. Perhaps one of the maintainers could think about changing this.. everything is explained in the docs except this little thing.. Bye, B. - 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
Re: Root password revisited
Date |Tue, 28 Aug 2001 19:09:49 -0700
>From |"Gregg Baker" <[EMAIL PROTECTED]>
Hello!
GB> Hi all, I got a "No Database Chosen". What's the syntax for adding the
GB> database? I tried *.*, mysql, and test between UPDATE and user but all
GB> returned syntax error.
GB> Thanks much, Gregg
GB> UPDATE user SET Password=PASSWORD("desiredpasswordhere") WHERE User="root";
Try to execute 'USE mysql' before your UPDATE command.
___
For technical support contracts, visit https://order.mysql.com/
This email is sponsored by SWSoft, http://www.asplinux.ru/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Grigory Bakunov <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB / SWSoft
/_/ /_/\_, /___/\___\_\___/
<___/ www.mysql.com
-
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
Re: Root password revisited
Hi all, I got a "No Database Chosen". What's the syntax for adding the
database? I tried *.*, mysql, and test between UPDATE and user but all
returned syntax error.
Thanks much, Gregg
UPDATE user SET Password=PASSWORD("desiredpasswordhere") WHERE User="root";
-
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
Root password revisited
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
