ahh .. help,
after i follow what u said,
and do the update in my password then flush privileges,
now i can't even access my database with the password .. .
so, how now ???
----- Original Message -----
From: "David Lidström" <[EMAIL PROTECTED]>
To: "Alice" <[EMAIL PROTECTED]>
Sent: Thursday, May 31, 2001 3:36 PM
Subject: RE: password assign for localhost
>
> You must, after updating the user table, FLUSH PRIVILEGES
>
> And you should also set the password using the PASSWORD-command.
>
> update mysql.user
> set password = PASSWORD('abc')
> where user = 'root'
>
> and then
>
> FLUSH PRIVILEGES
>
> /d
>
> -----Original Message-----
> From: Alice [mailto:[EMAIL PROTECTED]]
> Sent: den 31 maj 2001 09:24
> To: MySQL
> Subject: password assign for localhost
>
>
> at the moment, i am still connect to local host without a password.
> i did try to using query to update the MySQL db and update the user table
on
> it for the user where it is 'root'
> my asp prog did connected to my db which have the connection string that
the
> password is blank.
> but with the connection string (blank password), i still can update my db
> after i modify the root password.
>
> If i make u confuse, let me describe more further ...
> originally, my root 's password is blank, and i used this connection
string
> "Provider=MSDASQL.1;Persist Security Info=False;User ID=root;Data
> Source=abc"
> to connect it with my asp prog,
> later i reallize i should put the password for it, then i update the root
> password with this query,
>
> update mysql.user
> set password = 'abc'
> where user = 'root'
>
> then i run my asp prog, somehow i still can have processing in my db,
update
> , delete ..
> i wonder it shouldn't allow me to do that since the connection is no
longer
> correct..
> coz my password already been changed !!
>
> WHY ???
>
>
>
/---------------------------------------------------------------------------\
Confidential and/ or privileged information may be contained in this
e-mail and any attachments transmitted with it ('Message'). If you are
not the addressee indicated in this Message (or responsible for
delivery of this Message to such person),you are hereby notified that
any dissemination, distribution, printing or copying of this Message or
any part thereof is prohibited. Please delete this Message if received
in error and advise the sender by return e-mail. Opinions, conclusions
and other information in this Message that do not relate to the
official business of this company shall be understood as neither given
nor endorsed by this company.
This mail is certified Virus Free by *ProtectNow! (InternetNow Sdn Bhd)
*Scanner Engine powered by Norman Virus Control
\--------------------------------------------------------------------------/
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
