Tagged Questions
1
vote
1answer
275 views
How to properly secure MySQL database?
We have a web application based on the famous triad apache + php + mysql which we sell to our customers and gets installed on their servers.
Currently, we are using MySQL 5.1.41 which has only a ...
2
votes
2answers
421 views
Encrypt MySQL database on a Linux VPS?
I'm working on a rails app for our church, which stores some fairly sensitive information about our people in a MySQL database.
We have our own windows server running Hyper-V so the original ...
2
votes
3answers
345 views
Which database is best for deeply embedded database or through C DLL?
I want a deeply embedded database. Deeply embedded means that the server is started by an application and closed by the application with no tcp/ip or 0 port. The main features of consideration are:
...
1
vote
1answer
244 views
Does replication with SSL encryption work on MySQL 5.5?
I am trying to set up replication with slave on Amazon EC2 and master in our local environment. The setup went fine without SSL encryption. But when I set up the replication to be SSL encrypted, it is ...
1
vote
1answer
151 views
Randomly generated password for mysql admin over time?
I have this idea of making my database's Admin account secured by creating the following:
Trigger is activated every hour in mysql this trigger activates a stored procedure
Stored procedure ...
4
votes
2answers
2k views
MySQL encryption
I am thinking about encrypting some fields in MySQL database using MySQL's encryption functions. I can't find any good sources on how to properly implement it. Has anyone done this and have a good ...
1
vote
1answer
248 views
Is it possible to fetch or update table data by table field type?
Is it possible to fetch or update table data by field type? If possible please tell me with a sample code.
1
vote
2answers
626 views
MySQL: How does AES_ENCRYPT turn the password into a key?
I am trying to figure out how to create the best secure password for AES_ENCRYPT. Specifically, how long should the password be, and how it translates into the 128 bit key length that AES typically ...
1
vote
2answers
2k views
How do you encrypt data while performing a mysqldump?
My OS is windows 7.
How can I encrypt data while performing a mysqldump?
From the command prompt, can I take a mysqldump with encrypted varchar and texts values?
Please help me.
Thanks
