[CentOS] Problems with MySQL
Tony Schreiner
schreian at bc.edu
Mon Oct 2 17:36:12 UTC 2006
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
More information about the CentOS
mailing list