SET PASSWORD = PASSWORD('newpassword') does not work if user has host extension

2004-07-13 Thread Stephane Carre
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

RE: SET PASSWORD = PASSWORD('newpassword') does not work if user has host extension

2004-07-13 Thread Stephane Carre
Message- From: Stephane Carre To: [EMAIL PROTECTED] Sent: 7/13/04 5:01 AM Subject: SET PASSWORD = PASSWORD('newpassword') does not work if user has host extension 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