List:General Discussion« Previous MessageNext Message »
From:David (SST - Adelaide) Logan Date:January 30 2007 3:32am
Subject:RE: Safe DB Distribution
View as plain text  
Have you checked out
http://dev.mysql.com/doc/refman/5.0/en/encryption-functions.html, you should
be able to en/decrypt your data via these functions thereby rendering any
data on the disk totally useless unless the process comes through your mysql
server. You will have to configure mysql with openssl support though, I'm
sure you would be able to find a package somewhere that has that available.

You can then use mysql security to only allow access to the webserver user
so the php package is the only one that can access this.

Regards 


---------------------------------------------------------------
********** _/     **********  David Logan 
*******   _/         *******  ITO Delivery Specialist - Database
*****    _/            *****  Hewlett-Packard Australia Ltd
****    _/_/_/  _/_/_/  ****  E-Mail: david.logan@stripped
****   _/  _/  _/  _/   ****  Desk:   +61 8 8408 4273
****  _/  _/  _/_/_/    ****  Mobile: +61 417 268 665
*****        _/       ******    
******      _/      ********  Postal: 148 Frome Street,
********   _/     **********          Adelaide SA 5001
                                      Australia 
i    n    v    e    n    t                                   
---------------------------------------------------------------

-----Original Message-----
From: Suhas Pharkute [mailto:psuhas@stripped] 
Sent: Tuesday, 30 January 2007 1:55 PM
To: Ales Zoulek
Cc: mysql@stripped
Subject: Re: Safe DB Distribution

Yep, I do understand that, but when I give DB to someone, I do not want them
to see the database. I want them to access the database thr' the php
application.

It is very simple, I don't want any one to see my DB in open way. But they
can access it thr' my app.

I agree with about file system, and that will work on Linux but
unfortunately I am working on Windows(98/NT/XP)

any ideas!!!

Thx
Suhas

On 1/29/07, Ales Zoulek <ales.zoulek@stripped> wrote:
>
> What is it exactly that you need to achieve?
>
> PHP script doesnt read a MySQL data files, MySQL server does. You can
> configure your OS and filesystem rights, so that only MySQL server can
> read them.
>
> Ales.
>
>
> > ---------- Forwarded message ----------
> > From: "Suhas Pharkute" <psuhas@stripped>
> > To: mysql@stripped
> > Date: Mon, 29 Jan 2007 11:48:27 -0700
> > Subject: Safe DB Distribution
> > HI,
> >
> > I want to distribute the MySQL DB to different user with an PHP web app.
> My
> > biggest problem is MySQL data files. Is there anyway by which I can
> > configure the MySQL so that only PHP script can read it and if you
> happen to
> > copy the Data files and try to use it, that will be useless.
> >
> > I know, this is been in discussion before, but if I can get any other
> idea
> > to it, I would appreciate it
> >
> > Thank you in advance,
> > Suhas
> >
> >
> >
>
>
> --
> ------------------------------------------------------
> Ales Zoulek
> +420 604 332 515
> ICQ: 82647256
> http://www.al3x.cz/
> ------------------------------------------------------
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>
>


-- 
Suhas Pharkute, PhD
CEO - Syna Intelligence, LLP
V. 208 830 8915 (C)
E. sp@synaintel,.com
W. http://synaintel.com

Attachment: [application/x-pkcs7-signature] smime.p7s
Thread
Safe DB DistributionSuhas Pharkute29 Jan
  • Re: Safe DB DistributionFelix Geerinckx30 Jan
    • Re: Safe DB Distributionpeter lovatt30 Jan
      • Re: Safe DB DistributionDotan Cohen30 Jan
        • Re: Safe DB DistributionSuhas Pharkute30 Jan
    • Re: Safe DB Distributionmizioumt30 Jan
      • Re: Safe DB DistributionGerald L. Clark30 Jan
        • Re: Safe DB Distributionmizioumt30 Jan
        • Re: Safe DB Distributionmos30 Jan
  • Re: Safe DB DistributionFelix Geerinckx30 Jan
    • Re: Safe DB Distributionmizioumt30 Jan
Re: Safe DB DistributionAles Zoulek30 Jan
  • Re: Safe DB DistributionSuhas Pharkute30 Jan
    • RE: Safe DB DistributionSST - Adelaide)30 Jan
      • Re: Safe DB DistributionSuhas Pharkute30 Jan
      • Re: Safe DB DistributionSuhas Pharkute30 Jan
      • Re: Safe DB DistributionSuhas Pharkute30 Jan
        • Re: Safe DB DistributionDan Nelson30 Jan
          • Re: Safe DB DistributionAles Zoulek30 Jan