Re: old-password issue with mysqldump

2006-12-11 Thread Daniel da Veiga
Depending on the interface you're using, you can code an "on demand" convert function. You can keep your server running with the --old-passwords option till all your passwords are converted. So, you keep the --old-passwords option, when a user login, you test the password to see if its the new or

Re: old-password issue with mysqldump

2006-12-11 Thread Ahmad Al-Twaijiry
Hi Thanks, this is easy and simple if I just have few users :) I have more than 30,000 users :) I think there is no way to do this so I have to use old-passwords option in the new servers :) Thanks On 12/11/06, Daniel da Veiga <[EMAIL PROTECTED]> wrote: On 12/11/06, Ahmad Al-Twaijiry <[EMAIL

Re: old-password issue with mysqldump

2006-12-11 Thread Daniel da Veiga
On 12/11/06, Ahmad Al-Twaijiry <[EMAIL PROTECTED]> wrote: Hi everyone I'm using mysqld with option "old-passwords" in my server (let's call it serverA) and in my application I use "UPDATE . SET USERPWD=PASSWORD('ABCD')" to set the users password now I want to move my database to another se