Web2py on MySQL 8.0

[Fabio Ceccarani]

Hi,

I updated Linux Mint to last versione and MySQL was updated from version 5.7 to version 8.0.

Now my application return this error:

<class 'gluon.contrib.pymysql.err.InternalError'> (1043, u'Bad handshake')

I tried several possible solutions, install and reinstall pymysql, etc, etc... but nothing!

I tried to install mysq 5.7 but now it's hard to go back!

Someone encountered the same problem??!

Thanks!

Fabio

[Fabio Ceccarani]

Solved. The problem was PyMySQL for python 2.7 (used by my web2py).

With pip install PyMySQL it install for Python 3.8.

I installed PyMySQL for python 2.7 with:

wget https://bootstrap.pypa.io/pip/2.7/get-pip.py

python2 get-pip.py

python2 -m pip install PyMySQL