How does MySQL store sensitive data?
Five Ways to Protect Sensitive Data and Keep Your Database…
- Use certified encryption solutions to protect cardholder data.
- Encrypt cardholder data that is sent across open, public networks.
- Store encryption keys from your encrypted data on a certified encryption key management appliance.
What is meant by sensitive data?
Answer. The following personal data is considered ‘sensitive’ and is subject to specific processing conditions: personal data revealing racial or ethnic origin, political opinions, religious or philosophical beliefs; health-related data; data concerning a person’s sex life or sexual orientation.
How can I store sensitive data securely in a MySQL database?
Public keys can be stored with the user in DB, it is public. Private key can be encrypted with user’s password. When user logs in, you decrypt the private key and store it in his cookies (if you use SSL, it is not that bad place) or session. Both are not perfect but better than plain text in php file.
Is there a way to split in MySQL?
Obviously this could be done with explode in PHP or split in Perl using server-side script but what if you need to do it directly in MySQL. Surprisingly MySQL doesn’t have a dedicated function for this operations as opposed to split_part in PostgreSQL.
When to use separate lookup table in MySQL?
In most cases it is better to use a separate lookup table or a column for each field instead of storing data as comma-separated values for later lookup. However, there could be rare cases where the trick above could be useful.
How can I change the collation on an existing database?
You can also change the collation on an existing database via ALTER DATABASE. (For more information see the MySQL Database Character Set and Collation manual entry.) If however, only a single table needs to be treated as case sensitive, you could simply use: