Converting MySQL plain text password fields using MD5 algorithm

I expect mysql folks to help me with this -

I've a database with plain text passwords which I want to encrypt using MD5 encryption.

What query do I need to run?

Like 0 Replies 2

Replies

Welcome, guest

Join CrazyEngineers to reply, ask questions, and participate in conversations.

Sign up Log in

CrazyEngineers powered by Jatra Community Platform

  • shalini_goel14
    shalini_goel14

    @shalini-goel14-ASmC2J • Mar 25, 2009

    No replies yet, very strange.

    I don't know mysql but I guess if PL/SQL part can be done in mysql 😕 then write a procedure which is based on MD5 algorithm and then run that procedure. It will automatically encrypt all the passwords in your DB in a sinlge run.

    Please correct if anything wrong.

    Thanks

    0
  • ms_cs
    ms_cs

    @ms-cs-Ab8svl • Mar 25, 2009

    I want to know whether Is there any feature available as inbuilt to compress the data and store that?

    0