Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Generate & Insert Random User Password via MySQL?

Quote Reply
Generate & Insert Random User Password via MySQL?
Hello!

I'm sure I read this somewhere else in the forum a while back but I can't find the post.

What I've done is import data from LinkSQL 1.13 into the latest version, and to my happy surprise new user accounts have automatically been set up using the contact email address from the links - great.

What I need to do now though is generate new random passwords for all of the accounts.

I found this post in the forum which generates random code which does 1/2 of what I need, but it's for use in a script.

Does anyone know if there's a way to do it all via a mysql command?

Regan.

Last edited by:

ryel01: Jul 1, 2004, 6:44 PM
Quote Reply
Re: [ryel01] Generate & Insert Random User Password via MySQL? In reply to
Hi. Is this the thread you were looking for?

http://www.gossamer-threads.com/...i?post=193069#193069

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [Andy] Generate & Insert Random User Password via MySQL? In reply to
In Reply To:
Hi. Is this the thread you were looking for?
http://www.gossamer-threads.com/...i?post=193069#193069


That's the bugger - I knew I'd seen it somewhere.

You don't know how to mix letters in with numbers in that sql statement by any chance?

regan
Quote Reply
Re: [ryel01] Generate & Insert Random User Password via MySQL? In reply to
No problem :)

Only reason I found it, was because I asked exactly the same question about a year ago.. so I just looked for my post :D

Quote:
You don't know how to mix letters in with numbers in that sql statement by any chance?

Afraid not... sorry :(

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [Andy] Generate & Insert Random User Password via MySQL? In reply to
hehehe...

no worries - I think the numbers will do the trick anyway.

Regan.