MYSQL 8 / web2py compatibility

[jim kaubisch]

Hi,

Just in the process of migrating my web2py apps from macos 10.14 (Mojave) to 10.15 (Catalina). 

Most things seem to be going fine but migrating mysql isn't. 

Have been using v5.7 for years successfully with multiple versions of macos and web2py but now seem stuck

I've looked through mysql related questions on this group and the online book but see no statement that mysql v8 IS compatible with the current version of web2py. Please, what is the situation???

As a corollary, do any of you know the state of mysql support  (5.7 or 8) for Catalina? The mysql site is silent on the topic. 

This is an unexpected stumbling block 

Thanks for your help !!

[Toan Le]

Try change position adapter: gluon/packages/dal/pydal/adapter/mysql.py, line 10

drivers = ('MySQLdb', 'mysqlconnector', 'pymysql')