mysql用户&权限
创建用户
CREATE USER
{username}
@'
{host}'
IDENTIFIED BY
{password}
;
说明:username - 访问用户名;host - 访问主机,localhost(主机访问), 127.0.0.1(通过网卡主机访问), %(任意远程主机);password - 密码,可为空;
授权
GRANT {privileges} ON {database}.{table} TO {
username}
@
'{host}'
说明:privileges - 权限,select, udpate, all;database - 数据库,可用*;table - 表名,可用*;