Someone the other day said this worked:
started safe_mysqld with --skip-grant-tables and then did:
mysql -u root mysql
mysql> UPDATE user SET password=PASSWORD('abc') WHERE User='root'
-> AND Host='whichever host you want to match'
- Original Message -
From: "Mike Ryerse" <[EMAIL P
FORUM_CATEGORY_CAT_ID(CAT_ID), KEY
FORUM_CATEGORY_CAT_STATUS (CAT_STATUS) )
===
... and many more 3704 errors
Now if I enter root and leave password blank, it says Installation Complete
and has a test database link, I take the link and it's back to the "need to
logo
yes, i just tried and failed
- Original Message -
From: "Philip Daggett" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, August 29, 2001 9:50 AM
Subject: Problems getting into MySQL.com
> Is anybody else not able to get onto mysql.com???
>
>
> --
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";
-
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
