I have a mysql database with access via phpmyadmin as we have forgotten the password on the encrypted BLOB, How to change password or see the current password?
At least you should know the encryption algorithm/function. If you know it you just encrypt some password using it and do "update tablename set blob_password_field = 'new_encrypted_password' where some_condition". If you don't know the algorithm then you most probably have no chances neither to see the password, nor to change it.