I'm trying to work with a MySQL 5.5 table using QGIS 1.8. I can do "Add Vector Layer", choose "Database", and successfully connect to the MySQL connection I previously set up. QGIS shows me a "Select vector layers to add" dialog that lists the tables in my database, including the one I want to use which shows a "Geometry type" of "Point" (which is correct, there's a POINT column in that table). When I highlight that table from the list and click OK I get an error message:
The layer MySQL:[redacted connection info] is not a valid layer and can not be added to the map
Is there something that needs to be done to make a MySQL table a "valid layer" other than making sure that it has a geometry field (like a point)?