grantprivs.asp

asp与MYSQL的源码

<!--#include file="dsn.asp"-->
<%
'first, make sure person granting change has privs to grant change...

sql = "update mysql.user set " & request("priv") & " = '" & request("setting") & "' where user = '" & request("user") & "' and host = '" & request("host") & "'"
'Response.Write sql
set cn = server.CreateObject("ADODB.Connection")
cn.open dsn
cn.Execute sql

cn.Execute "flush privileges"

Response.Redirect "users.asp"
%>