UNIX and Linux Applications

hi, linux gurus...

i'm trying to write a script in ksh called ResetPass that allows a user to change mysql passwords. the script accepts user, password and host like this: ResetPass <user> <password> <host>. here's the code:


*****************************************************
mysql -BCNnqs --disable-pager -u system -pmanager << EOJ
use mysql;

set @user = '${1-.}';
set @pass = '${2-.}';
set @host = '${3-.}';

update user set password=password(@pass) where user=@user and host=@host;
flush privileges;

quit

EOJ
*****************************************************


when i only use this bit...

update user set password=password(@pass) where user=@user;

... it works. but when i add the part, "and host=@host", it no longer does. there's something clearly wrong with my syntax but i'm not sure what. the mysql manual itself, says to use this form:


*****************************************************
UPDATE mysql.user SET Password=PASSWORD('newpass')
WHERE User='bob' AND Host='%.loc.gov';
FLUSH PRIVILEGES;

*****************************************************

if anyone can see what i'm doing wrong, i would appreciate your advice. thanks!

ankimo

I believe that with the wild card % you should use the like operator:

Code:

update user set password=password(@pass) where user=@user and host like @host;

You should be careful, of course, with the matched records