I am using MySQL 4.0.18 on Windows. I want to give my users the possibility to change their MySQL password after they log in. The command SET PASSWORD = PASSWORD('newpassword') works fine as long as the user has been created with no specific host extension in the mysql database (corresponding to e.g. [EMAIL PROTECTED]). Now if the user is defined in the mysql database with a host extension ([EMAIL PROTECTED], for example), the SET PASSWORD command fails with the message "Can't find any matching row in the user table". For security reasons, I need the users to be defined with a host extension.
Is this a bug, or is there a way around this? (Please do not suggest to use SET PASSWORD FOR [EMAIL PROTECTED] = PASSWORD ('newpassword') as this is only allowed for users that have access to the mysql database!) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]