How to Generate Paswords using Mysql

How to generate passwords in Mysql: Update ‘table’ set ‘password’ = substring(md5(rand()),-8)