Michael,
> I get this error when trying to create grants for a user I know
> exists.Anyone know why this is happening?:
mysql>> grant all privileges on jpox.* to [EMAIL PROTECTED] identified by
> password 'password';
> ERROR 1133: Can't find any matching row in the user table
The error number is okay, but the error message is strange. What
MySQL version are you using?
It should look like:
mysql> SELECT VERSION();
+---------------+
| VERSION() |
+---------------+
| 4.0.13-max-nt |
+---------------+
1 row in set (0.04 sec)
mysql> GRANT ALL ON *.* TO 'someone'@'somewhere'
-> IDENTIFIED BY PASSWORD 'password';
ERROR 1133: Password hash should be a 16-digit hexadecimal number
And the correct GRANT statement would be:
mysql> GRANT ALL ON *.* TO 'someone'@'somewhere'
-> IDENTIFIED BY 'password';
The IDENTIFIED BY clause will take an unencrypted password. Before
that password is stored, it's encrypted.
Regards,
--
Stefan Hinz <[EMAIL PROTECTED]>
iConnect GmbH <http://iConnect.de>
Heesestr. 6, 12169 Berlin (Germany)
Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3
[filter fodder: sql, mysql, query]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
