Use SHOW GRANTS for the list of users...

http://dev.mysql.com/doc/refman/5.0/en/show-grants.html

On 02/10/06, AR <lists@tuxdoit.com> 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@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
_______________________________________________
CentOS mailing list
CentOS@centos.org
http://lists.centos.org/mailman/listinfo/centos