How to show mySQL BLOB data 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 3.3.9.2 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 = &lt;whateveruidyouwant&gt;;


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.