For a while I have been adding layers from my mySql database and all went well.
Then I got crashes when adding new vector layers.
Then I only got crashes and it is not possible to add layers from the mySql database any more (crash) or create a connection, then test it (crash). Sporadically I can get to the list of the tables in the mySql database after creating a new connection but usually QGIS crashes.
I tried deinstalling and reinstalling QGIS. Did not help.
I am using the menu "layer" > "add vector layer" > "database" (in German, so maybe a little different).
The table I am trying to add is named "tblTeilPopMassnPolygon", contains an id "TPopMassnPolygonId" with Primary Key and Auto Increment. Plus a polygon field "TPopMassnPolygonPolygon" and a field named "TPopMassnGuid", varchar 40, to save GUID's in. There are 6000 datasets in the table. I had tested them with the polygon data before and it worked. So there is probably nothing wrong with the data itself.
I tried using shorter names for table and fields but that didn't help.
How can I get QGIS to connect to my mySql tables again?