Use the MD5() function to create a 128-bit encrypted value: MD5()
mysql> mysql> mysql> SELECT MD5('MyPassword'); +----------------------------------+ | MD5('MyPassword') | +----------------------------------+ | 48503dfd58720bd5ff35c102065a52d7 | +----------------------------------+ 1 row in set (0.00 sec) mysql>