Problem with MySQL database: MD5

  • Thank you for such a wonderful tool. I tried to install it on our server and it work great.
    Because there are already many users on our server and username/password are stored in MySQL database.
    So I following the instruction fro the PDF document: 8.1.1. SQL Database Authentication

    I was not able to login with username/password pair from the database.
    The message was "Invalid username and/or password, please try again".
    I found out the problem was due to the password stored in the database was encoded with md5 method.
    If I manually change the password field in the database to a new value (without md5 encoded), then I can login to the system without problem.

    Could anyone show me how to config the system so that it will accept md5 encoded password? Please help!