Click here to get back home

MySQL Encryption
 Home | NewsGroups | Search | About
Login Password
Register Now!
 comp.lang.php    Post an article   get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content
Subject Author Date
MySQL Encryption Alan M Dunsmuir 07-05-2008
Posted by Alan M Dunsmuir on July 5, 2008, 5:14 am
Please log in for more thread options
 I'm writing a Web application using PHP5 connecting to a MySQL database.

I've told the client's application administrator to look after back-ups
of the database by using the "Export" option in phpMyAdmin to
automatically copy the database contents (recorded as SQL statements) to
his desktop.

Is there some way I can include encryption in this download process?
(And equivalently, decryption should he need to restore the database
from a backed up copy?) He is running a Windows machine, so for him to
do this locally, as a separate step, would require the use of some
Windows encryption code, and would risk his leaving a open text version
of the database on his desktop for anybody to see.

Posted by Dikkie Dik on July 5, 2008, 7:37 am
Please log in for more thread options
 Alan M Dunsmuir wrote:
> I'm writing a Web application using PHP5 connecting to a MySQL database.
>
> I've told the client's application administrator to look after back-ups
> of the database by using the "Export" option in phpMyAdmin to
> automatically copy the database contents (recorded as SQL statements) to
> his desktop.
>
> Is there some way I can include encryption in this download process?
> (And equivalently, decryption should he need to restore the database
> from a backed up copy?) He is running a Windows machine, so for him to
> do this locally, as a separate step, would require the use of some
> Windows encryption code, and would risk his leaving a open text version
> of the database on his desktop for anybody to see.

This is not really a PHP question, but there are a few ways to get to a
database hosted on a web server or separate dedicated database server.

For a web server, phpMyAdmin is a possibility. To do this safely over
the big bad internet, run it on https. (you can use a self-signed
certificate and give your own root certificate to the client if you do
not want to spend money on a web certificate).

Or, you can tunnel port 3306 (or whatever port MySQL is serving) to your
local PC using an SSH tunnel. PuTTY is a good SSH client. If you
restrict SSH access to just a few known IP addresses, you can build a
pretty secure maintenance facility. One advantage of tunneling is that
your client can use any database front-end program he likes. There are
even database front-end programs that have SSH tunneling support built-in.

Best regards.

Posted by Jerry Stuckle on July 5, 2008, 9:01 am
Please log in for more thread options
Alan M Dunsmuir wrote:
> I'm writing a Web application using PHP5 connecting to a MySQL database.
>
> I've told the client's application administrator to look after back-ups
> of the database by using the "Export" option in phpMyAdmin to
> automatically copy the database contents (recorded as SQL statements) to
> his desktop.
>
> Is there some way I can include encryption in this download process?
> (And equivalently, decryption should he need to restore the database
> from a backed up copy?) He is running a Windows machine, so for him to
> do this locally, as a separate step, would require the use of some
> Windows encryption code, and would risk his leaving a open text version
> of the database on his desktop for anybody to see.
>

Try comp.databases.mysql for your mysql questions. This is a PHP newsgroup.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================


Posted by Alan M Dunsmuir on July 5, 2008, 9:49 am
Please log in for more thread options
Jerry Stuckle wrote:
>
> Try comp.databases.mysql for your mysql questions. This is a PHP
> newsgroup.
>

No. It is actually a question about phpMyAdmin.

Posted by Jerry Stuckle on July 5, 2008, 10:00 am
Please log in for more thread options
Alan M Dunsmuir wrote:
> Jerry Stuckle wrote:
>>
>> Try comp.databases.mysql for your mysql questions. This is a PHP
>> newsgroup.
>>
>
> No. It is actually a question about phpMyAdmin.
>

In that case, he should be asking in the phpMyAdmin support forums, not
here.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================


Similar ThreadsPosted
mysql encryption tutorial? July 16, 2006, 10:19 pm
what's the Basic Encryption method used in mysql February 17, 2007, 12:00 am
encryption October 7, 2005, 8:37 pm
Binary Encryption November 3, 2004, 5:53 pm
Slightly OT: encryption March 11, 2005, 11:18 am
Asymmetric Encryption in PHP? March 23, 2005, 10:06 pm
PHP on Windows with Encryption April 18, 2005, 7:59 pm
Best encryption technique April 19, 2005, 12:11 pm
file encryption using PHP June 14, 2005, 8:04 pm
PHP querystring encryption, June 20, 2005, 12:06 pm

Our other projects:

Art Dolls, Fairies and Mermaids - Sunnyfaces.net

Roy's Linux, Programming and Search Engines messages

1-Script XML SitemapXML Sitemap