可以对MySql 5.0.x中的存储过程进行加密吗? [英] Can stored procedure in MySql 5.0.x be encrypted?

问题描述

在Microsoft Sql中，可以使用

In Microsoft Sql it is possible to encrypted stored procedures with

CREATE PROCEDURE dbo.foo 
WITH ENCRYPTION 
AS 
BEGIN 
    SELECT 'foo' 
END

这使人们停止查看存储过程代码.

This stops people looking at stored procedures code.

如何在 MySql 5.0.x中执行此操作?

How can I do this in MySql 5.0.x ?

推荐答案

您无法在MySQL中执行此操作.参见错误# 4210 .

You can not do this in MySQL. See bug #4210.

: Leonidas 中的评论/501122/can-stored-procedure-in-mysql-5-0-x-be-encrypted/501145#501145>这个问题的另一个答案需要在那里供任何人阅读，所以我我在这里引用它:

: The comment from Leonidas on another answer to this question needs to be out there for anyone to read, so I'm quoting it here:

混淆可以逆转.我发现 至少有一项通过Google的产品， 承诺会透露SP代码.所以我 认为/希望MySQL团队不会 困扰于默默无闻的安全性"或 更糟的是智力资产 保护"(如错误中所述 4210).

Obfuscation can be reversed. I found at least one product via Google, that promises to reveal the SP-code. So I think/hope that the MySQL-team won't bother with "security by obscurity" or even worse "intellectual asset protection" (as described in the bug 4210).

这篇关于可以对MySql 5.0.x中的存储过程进行加密吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！