mysql相应技巧

mysql相应技巧

更新数据库
UPDATE vpopmail SET pw_shell = '20971520s' WHERE pw_shell = '5242880S' and pw_domain="69vv.net";

更新数据库vpopmail使字段pw_shell = '20971520s'前提是使字段pw_shell = 'NOQUOTA'并且使字段pw_domain="chb.com"

UPDATE vpopmail SET pw_shell = '20971520s' WHERE pw_shell = '20971520s' and pw_domain="chb.com" and pw_id;

在数据库中建立最高权限用户
grant all privileges on 数据库.* to 用户名@localhoat identified by '口令';

grant 准予
all privileges 全部权限
identified by  以....为验证/口令

给某一数据库建立具有约束权限的数据库用户
CREATE DATABASE vpopmail;
GRANT select,insert,update,delete,create,drop ON vpopmail.* TO IDENTIFIED BY 'password';