mysql相应技巧
时间：2006-10-14 来源：b.s.d
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 vpopmailuser@localhost IDENTIFIED BY 'password';
更新数据库
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 vpopmailuser@localhost IDENTIFIED BY 'password';
相关阅读 更多 +
