##

-- release/opt
BugNumber=118025
rm -rf $BugNumber/
bin/mysqld --no-defaults --initialize-insecure --basedir=$PWD --datadir=$PWD/$BugNumber --log-error-verbosity=3
bin/mysqld_safe --no-defaults --mysqld-version='' --basedir=$PWD --datadir=$PWD/$BugNumber --core-file --socket=/tmp/mysql.sock  --port=3306 --log-error=$PWD/$BugNumber/log.err --mysqlx=0 --log-error-verbosity=3  --secure-file-priv="" --local-infile=1  2>&1 &

-- CLI session

bin/mysql -uroot -S/tmp/mysql.sock --local-infile
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 9.3.0 MySQL Community Server - GPL

Copyright (c) 2000, 2025, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> create database test;
Query OK, 1 row affected (0.005 sec)

mysql>

## use test case provided by reporter

[umshastr@bug117943:/bv/ushastry]$ python -m venv Bug118025
[umshastr@bug117943:/bv/ushastry]$ python --version
Python 3.9.21
[umshastr@bug117943:/bv/ushastry]$ source Bug118025/bin/activate
(Bug118025) [umshastr@bug117943:/bv/ushastry]$ vi Bug118025.py
(Bug118025) [umshastr@bug117943:/bv/ushastry]$ pip install --proxy=http://www-proxy.us.oracle.com:80 mysql-connector-python
Collecting mysql-connector-python
  Downloading mysql_connector_python-9.3.0-cp39-cp39-manylinux_2_28_x86_64.whl (33.8 MB)
     |████████████████████████████████| 33.8 MB 58 kB/s
Installing collected packages: mysql-connector-python
Successfully installed mysql-connector-python-9.3.0
WARNING: You are using pip version 21.3.1; however, version 25.0.1 is available.
You should consider upgrading via the '/bv/ushastry/Bug118025/bin/python -m pip install --upgrade pip' command.
(Bug118025) [umshastr@bug117943:/bv/ushastry]$
(Bug118025) [umshastr@bug117943:/bv/ushastry]$ python Bug118025.py
Traceback (most recent call last):
  File "/bv/ushastry/Bug118025.py", line 28, in <module>
    assert stream1 == result[0][0]
AssertionError
(Bug118025) [umshastr@bug117943:/bv/ushastry]$
(Bug118025) [umshastr@bug117943:/bv/ushastry]$


## CLI

umshastr@bug117943:/bv/ushastry/mysql-9.3.0]$ bin/mysql -uroot -S/tmp/mysql.sock --local-infile --skip-binary-as-hex
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 9.3.0 MySQL Community Server - GPL

Copyright (c) 2000, 2025, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> create database test;
Query OK, 1 row affected (0.005 sec)

mysql> use test
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> select data from binary_table;
+---------------------------+
| data                      |
+---------------------------+
| binary data with %s in it |
+---------------------------+
1 row in set (0.000 sec)

mysql>

-- truncate

mysql> truncate binary_table;
Query OK, 0 rows affected (0.021 sec)

mysql>

-- install mysql-connector-python==9.2.0


(Bug118025) [umshastr@bug117943:/bv/ushastry]$ pip uninstall mysql-connector-python
Found existing installation: mysql-connector-python 9.3.0
Uninstalling mysql-connector-python-9.3.0:
  Would remove:
    /bv/ushastry/Bug118025/lib/python3.9/site-packages/_mysql_connector.cpython-39-x86_64-linux-gnu.so
    /bv/ushastry/Bug118025/lib/python3.9/site-packages/mysql/*
    /bv/ushastry/Bug118025/lib/python3.9/site-packages/mysql_connector_python-9.3.0.dist-info/*
Proceed (Y/n)?
  Successfully uninstalled mysql-connector-python-9.3.0
(Bug118025) [umshastr@bug117943:/bv/ushastry]$ pip uninstall mysql-connector-python
WARNING: Skipping mysql-connector-python as it is not installed.
(Bug118025) [umshastr@bug117943:/bv/ushastry]$
(Bug118025) [umshastr@bug117943:/bv/ushastry]$ pip install --proxy=http://www-proxy.us.oracle.com:80 mysql-connector-python==9.2.0
Collecting mysql-connector-python==9.2.0
  Downloading mysql_connector_python-9.2.0-cp39-cp39-manylinux_2_28_x86_64.whl (33.9 MB)
     |████████████████████████████████| 33.9 MB 2.1 MB/s
Installing collected packages: mysql-connector-python
Successfully installed mysql-connector-python-9.2.0
WARNING: You are using pip version 21.3.1; however, version 25.0.1 is available.
You should consider upgrading via the '/bv/ushastry/Bug118025/bin/python -m pip install --upgrade pip' command.

-
Bug118025) [umshastr@bug117943:/bv/ushastry]$
(Bug118025) [umshastr@bug117943:/bv/ushastry]$ python Bug118025.py
(Bug118025) [umshastr@bug117943:/bv/ushastry]$

-- confirm data in binary_table

mysql> select data from binary_table;
+----------------------------+
| data                       |
+----------------------------+
| binary data with %%s in it |
+----------------------------+
1 row in set (0.000 sec)

mysql>