like MySQL public private encryption.
I don’t understand this question. Can you please rephrase the question? What exactly are you asking?
I want to encrypt my field in a table with private, public key combination with Asymmentic encryption?
https://dev.mysql.com/doc/refman/8.0/en/encryption-functions.html
You can also use encryption functions native to your programming language. For example, https://www.php.net/manual/en/ref.gnupg.php
Use BLOB columns within MySQL to store the encrypted data. Do the encrypting/decrypting within your code.
No, I was asking for Asymmetric Function like
MySQL :: MySQL 8.0 Reference Manual :: 6.6.3 MySQL Enterprise Encryption Usage and Examples
Unfortunately those functions are closed-source and are only available with a MySQL Enterprise contract from Oracle.
As I said above, your other option is to use your app’s programming language to do this and simply store the blob data in MySQL. You can also check out this plugin https://dev.mysql.com/doc/refman/5.7/en/keyring-udfs-general-purpose.html, which is available on PXC8, to store some secrets information.