I coded my script but i want to change password with mysql. (Maybe want to change a lot row). My password length have 8 character.
[MYSQL]
UPDATE mycostumerdata SET password=SUBSTRING(MD5(ROUND(RAND(9999)*1000)),1,8)
[/MYSQL]
You can add any coloum for better random password.
![[Ask]](http://www.idglabs.com/wp-content/plugins/bookmarkify/ask.png "<! :en >Create random password in mysql<! : >")
![[BlogBookmark]](http://www.idglabs.com/wp-content/plugins/bookmarkify/blogbookmark.png "<! :en >Create random password in mysql<! : >")
![[Bloglines]](http://www.idglabs.com/wp-content/plugins/bookmarkify/bloglines.png "<! :en >Create random password in mysql<! : >")
![[del.icio.us]](http://www.idglabs.com/wp-content/plugins/bookmarkify/delicious.png "<! :en >Create random password in mysql<! : >")
![[Digg]](http://www.idglabs.com/wp-content/plugins/bookmarkify/digg.png "<! :en >Create random password in mysql<! : >")
![[Facebook]](http://www.idglabs.com/wp-content/plugins/bookmarkify/facebook.png "<! :en >Create random password in mysql<! : >")
![[Furl]](http://www.idglabs.com/wp-content/plugins/bookmarkify/furl.png "<! :en >Create random password in mysql<! : >")
![[Google]](http://www.idglabs.com/wp-content/plugins/bookmarkify/google.png "<! :en >Create random password in mysql<! : >")
![[MySpace]](http://www.idglabs.com/wp-content/plugins/bookmarkify/myspace.png "<! :en >Create random password in mysql<! : >")
![[Netvouz]](http://www.idglabs.com/wp-content/plugins/bookmarkify/netvouz.png "<! :en >Create random password in mysql<! : >")
![[Segnalo]](http://www.idglabs.com/wp-content/plugins/bookmarkify/segnalo.png "<! :en >Create random password in mysql<! : >")
![[Slashdot]](http://www.idglabs.com/wp-content/plugins/bookmarkify/slashdot.png "<! :en >Create random password in mysql<! : >")
![[Spurl]](http://www.idglabs.com/wp-content/plugins/bookmarkify/spurl.png "<! :en >Create random password in mysql<! : >")
![[StumbleUpon]](http://www.idglabs.com/wp-content/plugins/bookmarkify/stumbleupon.png "<! :en >Create random password in mysql<! : >")
![[Technorati]](http://www.idglabs.com/wp-content/plugins/bookmarkify/technorati.png "<! :en >Create random password in mysql<! : >")
![[Twitter]](http://www.idglabs.com/wp-content/plugins/bookmarkify/twitter.png "<! :en >Create random password in mysql<! : >")
![[Windows Live]](http://www.idglabs.com/wp-content/plugins/bookmarkify/windowslive.png "<! :en >Create random password in mysql<! : >")
![[Yahoo!]](http://www.idglabs.com/wp-content/plugins/bookmarkify/yahoo.png "<! :en >Create random password in mysql<! : >")
Popularity: unranked [?]
No tags for this post.
