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