Is there a simple way to look at BLOB data that Drupal 7 stores in some tables?
There is a trick to configure phpmyadmin but apparently it's not working with version 22.214.171.124 that comes with MAMP.
If you need to peek, say into user->data, which is seralised data array, just use
drush sqlc to bring yourself to an sql command line, then type:
select uid, name data from users where uid = <whateveruidyouwant>;
This works for any data, and if you are brave you can even edit the serialized data via command-line but is not recommended unless you know what you are doing.
I would json_encode the array into a variable and spit it out via devel.
$var = json_encode($yourarray); dpm($var);