Hello.
Use SET PASSWORD=password('youpassword'). On 4.1.9 such queries works fine: mysql> show grants for current_user(); +----------------------------------------------------------------------------+ | Grants for [EMAIL PROTECTED] | +----------------------------------------------------------------------------+ | GRANT USAGE ON *.* TO 'vano'@'%' IDENTIFIED BY PASSWORD '6067079d6665cd0e' | +----------------------------------------------------------------------------+ 1 row in set (0.00 sec)
mysql> set password =password('v');
Query OK, 0 rows affected (0.00 sec)
As said at:
http://dev.mysql.com/doc/mysql/en/SET_PASSWORD.html
syntax as your can use only clients with access to mysql database.
Jason Joines <[EMAIL PROTECTED]> wrote:In 4.0.x and 3.23.x a user with these permissions: GRANT USAGE ON *.* TO 'bogus'@'%' IDENTIFIED BY PASSWORD '7f8933111c70fb1d'
could still change their own password with: set password for bogus = password('bogus');
After upgrading to 4.1.7 my users are getting this error:
ERROR 1044 (42000): Access denied for user 'bogus'@'%' to database 'mysql'
I did run mysql_fix_privilege_tables after the upgrade but then had to change to using old_passwords because of application problems. The upgrade seemed to change the above grants to:
GRANT CREATE TEMPORARY TABLES, LOCK TABLES ON *.* TO 'bogus'@'%' IDENTIFIED BY PASSWORD '7f8933111c70fb1d'.
However, users still receive this error when trying to change their password with either set of grants. Any ideas?
Thanks,
Jason Joines =================================
Thanks for the information. That was it. I'd read that document but guess I didn't pay enought attention to notice the difference.
Jason ===========
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
