php mysql权限控制,MySQL权限管理

/* CSS Document */

body {

font: normal 11px auto "Trebuchet MS", verdana, arial, helvetica, sans-serif;

color: #4f6b72;

background: #e6eae9;

}

a {

color: #c75f3e;

}

table{

padding: 0;

margin: 0;

border-left: 1px solid #c1dad7;

}

caption {

padding: 0 0 5px 0;

width: 700px;

font: italic 11px "Trebuchet MS", verdana, arial, helvetica, sans-serif;

text-align: right;

}

th {

font: bold 11px "Trebuchet MS", verdana, arial, helvetica, sans-serif;

color: #4f6b72;

border-right: 1px solid #c1dad7;

border-bottom: 1px solid #c1dad7;

border-top: 1px solid #c1dad7;

letter-spacing: 2px;

text-transform: uppercase;

text-align: left;

padding: 6px 6px 6px 12px;

background: #cae8ea url(images/bg_header.jpg) no-repeat;

}

th.nobg {

border-top: 0;

border-left: 0;

border-right: 1px solid #c1dad7;

background: none;

}

td {

border-right: 1px solid #c1dad7;

border-bottom: 1px solid #c1dad7;

background: #fff;

font-size:11px;

padding: 6px 6px 6px 12px;

color: #4f6b72;

}

td.alt {

background: #f5fafa;

color: #797268;

}

th.spec {

border-left: 1px solid #c1dad7;

border-top: 0;

background: #fff url(images/bullet1.gif) no-repeat;

font: bold 10px "Trebuchet MS", verdana, arial, helvetica, sans-serif;

}

th.specalt {

border-left: 1px solid #c1dad7;

border-top: 0;

background: #f5fafa url(images/bullet2.gif) no-repeat;

font: bold 10px "Trebuchet MS", verdana, arial, helvetica, sans-serif;

color: #797268;

} MySQL用GRANT,REVOKE命令授予和移除用户权限

CODE:

GRANT USAGE ON * TO 'will'@'localhost' IDENTIFIED BY 'will';

MySQL存储过程的权限控制:

建立存储过程时这样建立:

CODE:

CREATE PROCEDURE p()

SQL SECURITY INVOKER