Bug report #20563
MySQL connection fails
|Affected QGIS version:||3.4.1||Regression?:||No|
|Operating System:||Wundows 10||Easy fix?:||No|
|Pull Request or Patch supplied:||No||Resolution:|
|Crashes QGIS or corrupts data:||No||Copied to github as #:||28383|
When connecting to Mysql(v 5.7.22 and v 8 ) from QGIS no features are visible unless a filter is applied to the layer (eg select * from geo_polys).
Then the layer cannot be edited because of the active filter.
#2 Updated by steve smith about 3 years ago
I have set up two live databases for you to test.
I sent the connection details via email (as I would rather not put them on a forum) but not sure if you email notification was "no reply".
To recap : The mysql connection is working fine on Mysql 5.6 and all versions of Mariadb but has the "no features showing" problem on mysql 5.7 onwards.
The connection has always worked very smoothly and we started building our system round it. My client gives me no choice but Mysql.
Thanks again and in advance.