MYSQL_OPT_RECONNECT is deprecated

[davidtapia]

Hello,

Beginning with MySQL 8.0.34, the automatic reconnection feature is deprecated. The related MYSQL_OPT_RECONNECT option is still available but now returns a deprecation warning to the standard error output if your application calls the mysql_get_option() or mysql_options() function with the option, even when setting it to false.

Expect automatic reconnection functionality to be removed in a future version of MySQL.

Are you planning to remove the optional MYSQL_OPT_RECONNECT?

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

[grubba]

All use of MYSQL_OPT_RECONNECT appears to already be guarded by a corresponding configure test.

[davidtapia]

Can you explain how to disable the option?
Do you have any examples?

$ mysql --print-defaults

mysql would have been started with the following arguments:
--port=3306 --socket=/var/run/mysqld/mysqld.sock --reconnect=false

$ mysql --print-defaults

mysql would have been started with the following arguments:
--port=3306 --socket=/var/run/mysqld/mysqld.sock --skip-reconnect

But warning remain:

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

[davidtapia]

Hello,

In Pike-v8.0.1956/src/modules/Mysql/configure.in I comment the line 242: "#AC_CHECK_MYSQL_OPTIONS(MYSQL_OPT_RECONNECT)"

In Pike-v8.0.1956/src/modules/Mysql/configure I changed the line 6667:
$as_echo "/*#define HAVE_MYSQL_OPT_RECONNECT 1*/" >>confdefs.h

And the warning disappear. But I'm not sure that this is the way to apply the change...