Description of problem:

We are using this rpm to connect to MySQL with some scripts and we can't connect to MySQL without the latest version of this package.

We can't use tools (scripts python) on RedHat 8 and MySQL 8

Version-Release number of selected component (if applicable):

python3-PyMySQL-0.9.x ( not available )

How reproducible:

On RedHat 8.x (tested on 8.0 & 8.1) with MySQL 8.0.x
Of course, the redhat repositories are needed (enabled)

Steps to Reproduce:


    1. sudo yum update

    2. sudo dnf install @mysql:8.0

    3. sudo systemctl enable --now mysqld

    4. mysql_secure_installation

        No

        1234

        1234

        y

        n

        y

        y



   5. mysql -uroot -p1234

   6.  create user 'toto'@'localhost' identified with caching_sha2_password by '1234';

   7. exit

   8. sudo dnf install python3-PyMySQL

   9. echo "import pymysql
    conn = pymysql.connect(unix_socket='/var/lib/mysql/mysql.sock',user='toto', password='1234', connect_timeout=10, autocommit=True)
    print('connection successful')" > connect_mysql.py

   10. python3 connect_mysql.py



Actual results:

Traceback (most recent call last):
  File "connect_mysql.py", line 3, in <module>
    conn = pymysql.connect(unix_socket="/var/lib/mysql/mysql.sock",user="toto", password="1234", connect_timeout=10, autocommit=True)
  File "/usr/lib/python3.6/site-packages/pymysql/init.py", line 90, in Connect
    return Connection(args, *kwargs)
  File "/usr/lib/python3.6/site-packages/pymysql/connections.py", line 699, in init
    self.connect()
  File "/usr/lib/python3.6/site-packages/pymysql/connections.py", line 936, in connect
    self._request_authentication()
  File "/usr/lib/python3.6/site-packages/pymysql/connections.py", line 1165, in _request_authentication
    auth_packet = self._process_auth(plugin_name, auth_packet)
  File "/usr/lib/python3.6/site-packages/pymysql/connections.py", line 1227, in _process_auth
    raise err.OperationalError(2059, "Authentication plugin '%s' not configured" % plugin_name)
pymysql.err.OperationalError: (2059, "Authentication plugin 'b'caching_sha2_password'' not configured")



Expected results:


connection successful

Additional info:
With unsecure authentication, it works:


   1.mysql -uroot -p1234

    2. create user 'titi'@'localhost' identified with mysql_native_password by '1234';

    3. exit

    4. sed -i -e 's/toto/titi/g' connect_mysql.py

    5. python3 connect_mysql.py


When we update the package PyMySQL with pip: 


   1.  pip3 list | grep PyMySQL
     It should be (0.8.0)


   2. pip3 install -U PyMySQL==0.9.0 --user


   3. pip3 list | grep PyMySQL
     It should be (0.9.0)


   4.  python3 connect_mysql.py
     It works with the old insecure authentication plugin


   5. sed -i -e 's/titi/toto/g' connect_mysql.py


   6. python3 connect_mysql.py
     It works with the new secure authentication plugin :
     caching sha2: Trying fast path
     caching sha2: Trying full auth...
     caching sha2: Sending plain password via secure connection
     connection successful

     It's clear: an update of the official rpm is needed by RedHat 8 Linux to work securely with MySQL 8.0



5] Business justification/requirement to add the feature.

We have PCI DSS environments that require high security. Some security audit happen regularly and this authentication plugin (caching_sha2_password) is required to pass the audit.
So, we can't deploy MySQL 8 on RedHat 8.