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]