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 <danieldaveiga@gmail.com> wrote:
> On 12/11/06, Ahmad Al-Twaijiry <ahmadt@gmail.com> 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 server (serverB) and the
> > mysqld in this new server doesn't run with "old-passwords"
> >
> > so I dumped the databases from the first server (serverA) to a file
> > using mysqldump command and I imported it to the new server (serverB)
> > with command "mysql> source database.sql"
> >
> > now no one from my users can access to his account and I think it's
> > because the old-passwords is not enabled in the new server (serverB)
> >
> > I can enable "old-passwords" in the new server but I don't want to do
> > that (the new password format is more secure and better, right ?).
> >
> >
> > so is there anyway to convert all the password in my database to the
> > new password format ?
> >
>
> Start your new server with the --old-passwords option, login with your
> superuser (root or whatever you call it) and change its password to
> the new format:
>
> SET PASSWORD FORv 'some_user'@'some_host' = PASSWORD('newpwd');
>
> Then you can logout and restart your server without the
> --old-passwords option, and still login with the superuser, and with
> this account, you can set all your users passwords to the new format
> with a command just like the one above, check:
>
> http://dev.mysql.com/doc/refman/5.0/...d-hashing.html
>
> And you may find all information about passwords there.
>
> --
> Daniel da Veiga
> Computer Operator - RS - Brazil
> -----BEGIN GEEK CODE BLOCK-----
> Version: 3.1
> GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
> PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
> ------END GEEK CODE BLOCK------
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=ahmadt@gmail.com
>
>
--
echo "Hello World
"