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
> =================================
>
>
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
