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

Reply via email to