You will not be able to search on encrypted fields.
Sure you can. MySQL will also be able to use the index provided you are
using an "=" when searching. But you can't use ">" or "<" on an encrypted
field and still expect it to use an index.
I've found talking to MySQL developers about the
m: [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Tue, 30 Jan 2007 1:52 PM
Subject: Re: Safe DB Distribution
[EMAIL PROTECTED] wrote in news:[EMAIL PROTECTED]
R04.sysops.aol.com:
Something like distributing files with encrypted data in most columns
can be done
I think the OP is more concerned with
-Original Message-
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; mysql@lists.mysql.com
Sent: Tue, 30 Jan 2007 1:44 PM
Subject: Re: Safe DB Distribution
[EMAIL PROTECTED] wrote:
Something like distributing files with encrypted data in most columns
can be done, with the e
[EMAIL PROTECTED] wrote in news:[EMAIL PROTECTED]
R04.sysops.aol.com:
> Something like distributing files with encrypted data in most columns
> can be done
I think the OP is more concerned with protecting his datamodel, and this
cannot be done in my opinion.
--
felix
--
MySQL General Mailing
[EMAIL PROTECTED] wrote:
Something like distributing files with encrypted data in most columns
can be done, with the encryption key being a combination
of some hardware-related stuff such as MAC address that the user will
provide to you, and the key you generate and provide to the user.
Of course
chael
-Original Message-
From: [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Tue, 30 Jan 2007 4:08 AM
Subject: Re: Safe DB Distribution
[EMAIL PROTECTED] ("Suhas Pharkute") wrote in
news:[EMAIL PROTECTED]:
I want to distribute the MySQL DB to different user with an PHP web
Thank you everybody for your replies. Seems like I got an answer as no.
Thank you again,
Suhas
On 1/30/07, Dotan Cohen <[EMAIL PROTECTED]> wrote:
On 30/01/07, peter lovatt <[EMAIL PROTECTED]> wrote:
> Hi
>
> You probably cant make it 100% secure, because php is not a fully
compiled
> language
On 30/01/07, peter lovatt <[EMAIL PROTECTED]> wrote:
Hi
You probably cant make it 100% secure, because php is not a fully compiled
language, and as such an expert techie could probably add extra code to your
app that wouild allow access to the database, BUT you can get pretty close.
You will ne
Hi
You probably cant make it 100% secure, because php is not a fully compiled
language, and as such an expert techie could probably add extra code to your
app that wouild allow access to the database, BUT you can get pretty close.
You will need to encrypt everything in the database using MySql e
[EMAIL PROTECTED] ("Suhas Pharkute") wrote in
news:[EMAIL PROTECTED]:
> I want to distribute the MySQL DB to different user with an PHP web
> app.
Make sure you have read and understood the MySQL licensing policy, if your
app is not open source (as it seems to be).
> My biggest problem is MyS
On 1/30/07, Dan Nelson <[EMAIL PROTECTED]> wrote:
In the last episode (Jan 29), Suhas Pharkute said:
> Ok, I will explain it again,
>
> I need a way so that if some body gets the DB files (.MYD and .MYI)
> from my distribution, they can put it in their DB engine and can read
> my DB. I would like
In the last episode (Jan 29), Suhas Pharkute said:
> Ok, I will explain it again,
>
> I need a way so that if some body gets the DB files (.MYD and .MYI)
> from my distribution, they can put it in their DB engine and can read
> my DB. I would like to STOP this stealing.
>
> Is there any way?
If
Ok, I will explain it again,
I need a way so that if some body gets the DB files (.MYD and .MYI) from my
distribution, they can put it in their DB engine and can read my DB. I would
like to STOP this stealing.
Is there any way?
Thanks
Suhas
ent
---
-Original Message-
From: Suhas Pharkute [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 30 January 2007 1:55 PM
To: Ales Zoulek
Cc: mysql@lists.mysql.com
Subject: Re: Safe DB Distribution
Yep, I do understand that, but when I give DB to someone, I
ent
---
-Original Message-
From: Suhas Pharkute [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 30 January 2007 1:55 PM
To: Ales Zoulek
Cc: mysql@lists.mysql.com
Subject: Re: Safe DB Distribution
Yep, I do understand that, but when I give DB to someone, I
t
---
-Original Message-
From: Suhas Pharkute [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 30 January 2007 1:55 PM
To: Ales Zoulek
Cc: mysql@lists.mysql.com
Subject: Re: Safe DB Distribution
Yep, I do understand that, but when I gi
configure your OS and filesystem rights, so that only MySQL server can
read them.
Ales.
> -- Forwarded message --
> From: "Suhas Pharkute" <[EMAIL PROTECTED]>
> To: mysql@lists.mysql.com
> Date: Mon, 29 Jan 2007 11:48:27 -0700
> Subject: Safe DB Distrib
ROTECTED]>
To: mysql@lists.mysql.com
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 ca
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, th
19 matches
Mail list logo
