How to encrypt mysql database?

Question

I want to encrypt mysql database so when someone open phpmyadmin data is encrypted.I want to do without changing code at application layer. I already try key ring plugin but it's not work with table or column level

try this https://serverfault.com/questions/538715/whats-a-good-way-to-encrypt-a-mysql-database-and-is-it-worth-it — Ashok Kumar N, Feb 07 '19 at 16:53
I don't want to change query and code .is there any method available. — It prog, Feb 07 '19 at 16:56
Yes db method. Question is that make database encrypted without changing code and sql query — It prog, Feb 07 '19 at 16:59
If you want a magical pony that can do this, Stack Overflow can't help. What you're asking for is not possible. If you encrypt in such a fashion that a database client like phpMyAdmin can't see the data then you **must** change the application code. — tadman, Feb 08 '19 at 02:10

score 3 · Answer 1 · answered Feb 08 '19 at 02:08

This is an absolutely impossible objective.

phpmyadmin accesses the data in the database using exactly the same mechanisms as your application code -- nothing more, nothing less. If the data were encrypted from phpmyadmin's perspective, it would also be encrypted from the application's perspective, and the application in its current state would be unable to use it.

How to encrypt mysql database?

1 Answers1