Method and system for switching AES (Advanced Encryption Standard) and national password based on MySQL encryption algorithm

Abstract

The invention discloses an AES and national password switching method and system based on a MySQL encryption algorithm, and belongs to the field of databases. The method comprises the following steps: creating a global variable (curricular variable) for identifying a current encryption algorithm type, defining a switched encryption algorithm type (curricular variable) in a MySQL configuration file, creating a system table (curricular variable), restarting a MySQL service, screening all encrypted data tables in the MySQL, storing results and related default values in the created system table, and storing the results and the related default values in the system table. The method comprises the following steps of: performing data conversion in a multi-thread manner, traversing table information of a table stored in a system, storing data of an original table in a plaintext manner by creating a temporary table, deleting the original table, replacing the original table with the temporary table, updating the table information in the system table, and after all data tables are successfully converted, switching an encryption algorithm to an encryptallogistic mtype, so as to complete encryption of the system table. All the converted plaintext data tables are encrypted and stored, switching of encryption algorithms is completed, a system table encryptalverthmtransfer is deleted, and the MySQL service is started.

Description

technical field [0001] The invention discloses a switching method and system based on MySQL encryption algorithm AES and national secret, and relates to the technical field of databases. Background technique [0002] MySQL is a secure, cross-platform, efficient database system that is closely integrated with mainstream programming languages ​​such as PHP and Java. Currently, MySQL is widely used in small and medium-sized websites on the Internet. MySQL Community Edition starts from 5.7.11 Support table-based data encryption scheme, its encryption algorithm is AES, the encryption algorithm is single, which cannot better meet the user's requirements for MySQL data security; the national secret algorithm is a set of data encryption processing algorithms independently developed and innovative in my country, from SM1 -SM4 implements algorithm functions such as symmetric, asymmetric, and digest, respectively. [0003] It is particularly important to realize the switch of MySQL encr...

AI Technical Summary

Problems solved by technology

[0002] MySQL is a secure, cross-platform, efficient database system that is closely integrated with mainstream programming languages ​​such as PHP and Java. At present, MySQL is widely used in small and medium-sized websites on the Internet. The MySQL Community Edition starts from 5.7.11 Support table-based data encryption scheme, the encryption algorithm is AES, the encryption algorithm is single, can not better meet the user's requirements for MySQL data security; the national secret algorithm is a series of data encryption processing algorithms independently developed and innovated by my country, from SM1 -SM4 implements algorithm functions such as symmetric, asymmetric, and digest respectively

[0003] It is particularly important to realize the switching of MySQL encryption algorithm from AES to national secret; but currently there is no way to switch MySQL from the default encryption algorithm AES to national secret;

Images