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 UPDATE user SET

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 messages

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

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;