MySQL权限问题

2、设置权限账户

<span style="color: #000000">命令格式如下
GRANT 权限 ON 数据库.表 TO </span><span style="color: #800000">‘</span><span style="color: #800000">账户名</span><span style="color: #800000">‘</span>@<span style="color: #800000">‘</span><span style="color: #800000">账户类型</span><span style="color: #800000">‘</span>  IDENTIFIED BY <span style="color: #800000">‘</span><span style="color: #800000">密码</span><span style="color: #800000">‘</span><span style="color: #000000">
权阴有‘SELECT’、‘INSERT’、‘UPDATE’、‘DROP’、‘CREATE’、或‘ALL’
GRANT SELECT ON table.employee TO </span><span style="color: #800000">‘</span><span style="color: #800000">zhangsan</span><span style="color: #800000">‘</span> @ <span style="color: #800000">‘</span><span style="color: #800000">localhost</span><span style="color: #800000">‘</span> IDENTIFIED BY ‘<span style="color: #800080">123456</span>’

MySQL权限问题

标签：san   加密   密码   set   drop   查看   服务   span   ble