On Oct 2, 2006, at 12:49 PM, AR wrote: > Hello, > > Sorry for posting this here, but i've posted in MySQL list and no one > answered. > > I'm trying to set a password for a user with the command: > > mysql> set password for gamito at localhost=password('blabla'); > > but i always get the error: > ERROR 1133 (42000): Can't find any matching row in the user table > > although i'm pretty sure that the user exists. > > I'm using MySQL version 4.1.20 from CentOS 4.4 > > This neves happened to me :( > > Any help would be appreciated. > > Best Regards, > AR The user name and hostname each need to be in quotes mysql> set password for 'gamito'@'localhost' = password('blabla'); Tony Schreiner