Hi, all,
I had just upgrade my mySQL to version 4.0.15 yesterday.
I have now encountered error in remotely connect to mysql database with the user only have a particular db access rights.
 
The scenerio is like this,
in my mysql user db, i have one user call UserA,
which this UserA only have the rights to access 1 of my database called Database1,
when i connect remotely using my front end tool (mySQL Front),
it able to access and see ALL the databases NAME(although it shd only see Database1).
 
However, when i click on the Database1 or any of the databases,
i got the following error and not able to proceed to see my data.
 
Access Violation at address 10007504 in module 'libmysql.dll'. Read of address 00000000
 
Pls help !!
 
Note : if the user have no restriction in db, then will be no problem in accessing. It only happend if the user have restriction in db access.
 
regards,
alice
/---------------------------------------------------------------------------\

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

\--------------------------------------------------------------------------/

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to