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

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@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

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

mysql> set password for 'bar'@'localhost' = password ('baz'); Query OK, 0 rows affected (0.04 sec)

mysql>