Does anybody know of any compatibility issues or quirks with MySQL Community Server/Workbench on macOS Sierra? I recently did an installation on a Mac that had never held MySQL before and it doesn't seem to be working correctly. (Now maybe I just set it up wrong, but the since the installer offers no advanced options that doesn't seem to be the case.)
I can create schemas and tables, but when I go to actually query the table nothing happens. The activity indicator spins endlessly. I took a look at Activity Monitor and it doesn't show mysqld actually doing anything—the whole setup just appears to be deadlocked. Any ideas?
Here's what I'm trying to use:
I think I figured it out! It could have something to do with the length of the password. At first I had just set it up with a single-character password for my convenience, but I ran into some issues when trying to connect the Eclipse BIRT reporting software with MySQL. I changed the password to make it longer, and that solved the problem with BIRT, but even better, it seems to have solved the problem with Workbench as well!