Database Firewall

The most impressive feature of MySQL security is the Database Firewall. The firewall works with a fairly simple process. You record the queries on a certain database system for a certain time-frame and then add the queries to a white-list. After this period you lock the firewall and the system only allows these queries and rejects all others. This means that the spreadsheet Controllers are less a threat to data leakages. Since they only allow them to get the data they need and not the whole schema. (It is my personal opinion that connecting excel to a database via JDBC is fundamentally wrong).

Via the database firewall you limit the queries executed on the system to the legitimated list and avoid SQL injection. Technical background about the MySQL Database Firewall is available in this excellent blog by Tony Darnell.

Source:https://dev.mysql.com/doc/refman/5.6/en/firewall.html

Do you want additional information on MySQL security. Then I can advise the following documents from Oracle and the video by Mike Frank of the MySQL team.

摘自：https://technology.amis.nl/2015/09/25/mysql-database-security-mysql-database-firewall/

最新文章

1. Linux.NET学习手记（6）
2. [Zigbee]定时器1
3. JSON TO NSDictionary Mac & iOS
4. 如何使用国内源部署Ceph？
5. string.join加引号
6. android 开发过程中碰到的 Failed to create the part's controls 问题
7. python 面向对象简单理解
8. Asp.Net WebAPI 中Cookie 获取操作方式
9. python-登录-注册-修改密码
10. poj--1517
11. 关于Hibernate
12. 【tyvj1463】智商问题 [分块][二分查找]
13. lua lua解读
14. nginx之location配置详解及案例
15. ubuntu安装输入法
16. JQuery 操作数组 each、map、grep、filter
17. Elaticsearch 集群
18. web理论知识--HTML结构及标签
19. Form嵌入到Panel里(C#)
20. forEach遍历数组对象且去重

热门文章

1. unittest多线程生成报告（BeautifulReport）
2. [Go]GOPATH相关知识点
3. 【Kubernetes】Kubernetes的Service外部访问方式：NodePort和LoadBalancer
4. POJ 1276 Cash Machine 【DP】
5. java Web项目Service层通用接口和entityVo对象与entity对象转化问题的解决方案
6. PHP 基础复习 2018-06-17
7. poj1308+HOJ1325,判断是否为树
8. ***apache做301重定向的方法
9. MongoDB学习day09--Mongoose数据校验
10. mybatis结合generator进行分页插件PluginAdapter开发