Hi,

Check for the user in the 'User' Table of 'mysql' database. If there exists 'gamito' User in the User table, then set password will surely do.

Verify:

mysql>use mysql;
mysql>select * from user;


Thanks
ViSolve DB Team.
----- Original Message ----- From: "Deckard" <[EMAIL PROTECTED]>
To: <mysql@lists.mysql.com>
Sent: Monday, October 02, 2006 3:04 AM
Subject: Can't set password for user


Hello,

I'm trying to set a password for a user with the command:

mysql> set password for 'gamito'@'localhost'=password('bla');

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 he user exists.

I'm using MySQl version 4.1.20

Any help would be appreciated.

Best Regards,
Deckard

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to