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:

---------------
user()
[EMAIL PROTECTED]
---------------

After I enter:
SET PASSWORD FOR [EMAIL PROTECTED]('mypassword');

ERROR 1146: Table mysql.user does not exist.

How is this possible?

- Matt


-----Original Message----- From: [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 errors
for me on MySQL Version 4.0.16.max-nt.

Make sure that you are logged in as root.

C : \ >select user();

Sometimes MySQL is cryptic about 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 this:



c:\>cd C:\mysql\bin

c:\mysql\bin>mysql -uroot -p

mysql>SET PASSWORD FOR [EMAIL PROTECTED]('mypassword');



I get the following familiar message:



You have an error on your SQL syntax.  Check the manual that corresponds
to
your MySQL server version for the right syntax to use near
'PASSWORD('mypassword')' at line 1



Why does this not set my password correctly?



-Matt



  _____

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, October 18, 2004 1:35 PM
To: [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.

You should now be able to manage all your account info.

dave








"Perry, Matthew (Fire Marshal'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 privileges to update tables in the mysql database to be able to change passwords for others". What could I be doing incorrectly?

-Matt

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php



Reply via email to