Access control method and access control system

Abstract

The embodiment of the invention relates to the technical field of database access, in particular to an access control method and system. An MySQL server can obtain a binding relationship between a domain name and a current public network exit IP; when the current public network exit IP is inconsistent with the target public network exit IP bound with the domain name, the office intranet server isallowed to access through the current public network exit IP, the target public network exit IP bound with the domain name in the MySQL server is upadeted to the current public network exit IP. Only the office intranet server corresponding to the current public network exit IP is allowed to access the MySQL server, the data security of the MySQL server is ensured, and the risk of data leakage is reduced. A current public network exit IP is an IP carried by an office intranet server; therefore, a fixed public network IP and a VPN special line do not need to be applied for the office intranet server, the office intranet server does not need to pay related expenses of line building and line deployment to an internet service provider, and the cost of the office intranet server side can be reduced.

Description

technical field [0001] The invention relates to the technical field of database access, in particular to an access control method and an access control system. Background technique [0002] With the development of big data technology, data storage presents a multi-terminal distribution. For example, data can be stored in the cloud, database platform, local device or data collection terminal, etc. Generally speaking, the enterprise end obtains corresponding data services by accessing the cloud or database platform. [0003] However, some enterprises may not apply for a fixed public network IP. In this case, the enterprise mainly accesses the cloud or database platform through the following methods: [0004] (1) The cloud or database platform enables all external IP access, so that enterprises without fixed public network IP can freely access the cloud or database platform. [0005] (2) The enterprise side upgrades the office environment, applies for a fixed public network I...

AI Technical Summary

Problems solved by technology

[0007] However, the first method mentioned above is difficult to ensure the data security of the cloud or database platform because all external IP access is enabled, which will increase the risk of data leakage

In addition, although the above-mentioned second and third methods can ensure the data security of the cloud or database platform, if you apply for a fixed public network IP and VPN private line connection, you need to pay the Internet service provider related fees for line construction and line deployment. This will increase the cost on the enterprise side

Images