What were you trying to do that didn't work?

Run a perl script using DBD::mysql

What is the impact of this issue to you?

The new deprecation warning can break existing scripts

Please provide the package NVR for which the bug is seen:

perl-DBD-MySQL-4.053-1.el9.0.1.x86_64

How reproducible is this bug?:

100%

Steps to reproduce

1.  write a perl script that uses DBD::MySQL
2. do a connection to an existing database in the script
3. it will output the deprecation warning

Expected results

One can connect to a MySQL database from a perl script with nothing written to STDERR when it is successfull

Actual results

On connections this is written to STDERR

WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version.

And can break apps that use perl utilities into thinking a real error happened.

Not that using

DBI->connect($driver,'acct', undef, { mysql_auto_reconnect => 0 } )

DOES NOT prevent the deprecation warning as it is being set after the connection is already made.

The following is a thread of this being fixed on Ubuntu

Bug #2031548 "8.0.34 client lib change in behavior/output - new ..." : Bugs : mysql-8.0 package : Ubuntu