Re: Root password revisited

2001-08-29 Thread B. van Ouwerkerk
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 messag

Re: Root password revisited

2001-08-29 Thread Grigory Bakunov
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> UPDA

Re: Root password revisited

2001-08-28 Thread Gregg Baker
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"; -

Root password revisited

2001-08-28 Thread Gregg Baker
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 co