If I uninstall mysql with brew, does it drop the databases too?
Depends on the location of the database file on disk.

Upon uninstalling mysql, the mysql installation directory is deleted, which is /usr/local/Cellar/mysql in the default install.