One Blog

MySQL

insert into user (firstname, lastname, login_name, password, role) values('Lau', 'Wah', 'lauwah', 'haha', 'admin');"

update user set password = "new-password" where user='lauwah';

insert into user (user, password, host) values('lauwah', password('lauspass'), 'localhost');

delete from passwordattempts where login_name="lauwah";

Labels: MySql, tech

posted by 一零一零 @ 3/03/2009