Dear Alice, > but what i meant is my customer want to have the access on their database. > and i don't want them to view those databases that not belongs to the > particular customer. customer only access their own database only.
In MySQL < 4.0.5a: Start the server with --safe-show-databases In MySQL >= 4.0.5: GRANT ... ON customer1_db.* TO 'customer1'@'localhost' IDENTIFIED BY 'customer1_pw' If not explicitely granted, this command will not grant the "show databases" privilege, so customer1 cannot see other databases except for customer1_db. Hope it helps, -- Stefan Hinz <[EMAIL PROTECTED]> Geschäftsführer / CEO iConnect GmbH <http://iConnect.de> Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 ----- Original Message ----- From: "Alice Tan" <[EMAIL PROTECTED]> To: "Pae Choi" <[EMAIL PROTECTED]>; "MySQL" <[EMAIL PROTECTED]> Sent: Friday, November 29, 2002 2:54 AM Subject: Re: MySQL secure access > of course i will full access on those databases in all the databases store > in > our server, and i able to view/update all of them. > > but what i meant is my customer want to have the access on their database. > and i don't want them to view those databases that not belongs to the > particular customer. customer only access their own database only. > > > ----- Original Message ----- > From: "Pae Choi" <[EMAIL PROTECTED]> > To: "Alice Tan" <[EMAIL PROTECTED]>; "MySQL" <[EMAIL PROTECTED]> > Sent: Thursday, November 28, 2002 8:33 PM > Subject: Re: MySQL secure access > > > > If I am your customer and the data related to my web contents and/or > > services stored(this is more than likely if the hosting service is used) > > in the database at your site, I would definitely claim that the access to > > data will be appropriate. Ex, You have Web services using a hosting > > service. And the Web services collect the customers' info. Shouldn't > > you need to access the database which stored all your customers' info. > > > > In addition, it's a trust-based relationship. But the hosting service > should > > not have access to the customers' data even though the customers' > > databases reside at the hosting site. That's more appropriate in the > > business process and prevent the possible legal matter. Because the > > customers can simply claim that "It's my data and not yours!" > > > > The right practice will be to seperate your company's database and > > customer's databases on different hosts. And your company can provide > > the proper access to your customers to their databases. Otherwise, they > > will move on to somewhere else who can do for their needs. > > > > > > > > Pae > > > > > > > > > Hi, all, > > > > > > I am now using MySQL with MySQL Front, where i knew that it can > access > > > ALL > > > the databases that store remotely. > > > > > > My company is doing hosting services. And we are using MySQL as > > > our database system. Currently, we have our own databases + customer's > > > databases > > > store in our hosting server. But our customer requested to have their > > > own access on their databases, which i don't want them to see those > > > databases > > > that not belongs to them. Can i do that ? > > > > > > Thanx in advance for anyhelp. > > > > > > 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 > > > > > > > > > \----------------------------------------------------------------------- ---/ > > > > > > > > > --------------------------------------------------------------------- > > > 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 > > > > > > > > > --------------------------------------------------------------------- > > 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 > > > > > > > > > > > > > /----------------------------------------------------------------------- ----\ > > 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 > --------------------------------------------------------------------- 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
