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 this:
c:\cd C:\mysql\bin
c
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 parenthesis? There
shouldn't
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 errors
for me
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]
10/19/2004 11:09 AM
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 select user();
It outputs
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.
You should now be able to manage all your account info.
dave
Perry, Matthew (Fire Marshal's Office) [EMAIL