when you log on, there is no default database set to use
type: use mysql
bastien
From: "Perry, Matthew (Fire Marshal's Office)" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] setting root password
Date: Tue, 19 Oct 2004 11:09:56 -0500
I entered sele
x27;s Office)
Subject: RE: [PHP-DB] setting root password
try
mysql\> use mysql
then
mysql\>show tables
is the user table there?
if not, have you dropped the user table?
David
"Perry, Matthew (Fire Marshal's Office)" <[EMAIL PROTECTED
om: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 19, 2004 8:37 AM
To: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] setting root password
Matt,
Is there a space between PASSWORD and the opening parenthesis? There
shouldn't be, if there is. Otherwise, your statement worked without er
try
set password for 'root'@'localhost' = PASSWORD('somepassword');
bastien
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] setting root password
Date: Tue, 19 Oct 2004 08:36:37 -0500
Matt,
Is there a space between PASSWORD and the opening paren
bout its error messages for security reasons.
dave
"Perry, Matthew (Fire Marshal's Office)" <[EMAIL PROTECTED]>
10/19/2004 08:24 AM
To:
[EMAIL PROTECTED]
cc:
Subject:
RE: [PHP-DB] setting root password
After going to the command prompt I have done exactly
[EMAIL PROTECTED]; Perry, Matthew (Fire Marshal's Office)
Subject: Re: [PHP-DB] setting root password
If you haven't yet deleted the localhost root account, you can log onto the
mysql client with:
mysql> mysql -uroot -p
then press enter again when it prompts you for a password.
s Office)" <[EMAIL PROTECTED]>
10/18/2004 01:28 PM
To:
[EMAIL PROTECTED]
cc:
Subject:
[PHP-DB] setting root password
I have tried the step-by-step methods listed on mysql.com for setting a
root
password for my local server but I keep getting the message "you must have
I have tried the step-by-step methods listed on mysql.com for setting a root
password for my local server but I keep getting the message "you must have
privileges to update tables in the mysql database to be able to change
passwords for others". What could I be doing incorrectly?
-Matt