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]