RE: [PHP-DB] setting root password

2004-10-19 Thread Perry, Matthew (Fire Marshal's Office)
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. You should now be able to manage all your account info

RE: [PHP-DB] setting root password

2004-10-19 Thread dpgirago
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

RE: [PHP-DB] setting root password

2004-10-19 Thread Bastien Koert
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

RE: [PHP-DB] setting root password

2004-10-19 Thread Perry, Matthew (Fire Marshal's Office)
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

RE: [PHP-DB] setting root password

2004-10-19 Thread Perry, Matthew (Fire Marshal's Office)
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

RE: [PHP-DB] setting root password

2004-10-19 Thread Bastien Koert
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

Re: [PHP-DB] setting root password

2004-10-18 Thread dpgirago
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