-- 8.0.40 Env --- cat /etc/*release Oracle Linux Server release 7.9 NAME="Oracle Linux Server" VERSION="7.9" ID="ol" ID_LIKE="fedora" VARIANT="Server" VARIANT_ID="server" VERSION_ID="7.9" PRETTY_NAME="Oracle Linux Server 7.9" ANSI_COLOR="0;31" CPE_NAME="cpe:/o:oracle:linux:7:9:server" HOME_URL="https://linux.oracle.com/" BUG_REPORT_URL="https://bugzilla.oracle.com/" ORACLE_BUGZILLA_PRODUCT="Oracle Linux 7" ORACLE_BUGZILLA_PRODUCT_VERSION=7.9 ORACLE_SUPPORT_PRODUCT="Oracle Linux" ORACLE_SUPPORT_PRODUCT_VERSION=7.9 Red Hat Enterprise Linux Server release 7.9 (Maipo) Oracle Linux Server release 7.9 -- Server start-up BugNumber=116835 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-port=33330 --mysqlx-socket=/tmp/mysql_x_ushastry.sock --log-error-verbosity=3 --secure-file-priv="" --local-infile=1 2>&1 & $ bin/mysql -uroot -S/tmp/mysql.sock Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 7 Server version: 8.0.40 MySQL Community Server - GPL Copyright (c) 2000, 2024, 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 user 'ushastry'@'%' identified by 'mysql123'; Query OK, 0 rows affected (0.01 sec) mysql> grant all on *.* to 'ushastry'@'%'; Query OK, 0 rows affected (0.00 sec) mysql> \! hostname -f **.**.com mysql> \q Bye -- create schema $ bin/mysql -uroot -S/tmp/mysql.sock < /home/umshastr/work/binaries/utils/sakila-db/sakila-schema.sql $ bin/mysql -uroot -S/tmp/mysql.sock < /home/umshastr/work/binaries/utils/sakila-db/sakila-data.sql $ ### Env VS 2022, Python 3.11, Connector/Python 9.1.0 on Microsoft Windows Server 2022 Standard (pls ignore OS version from the script) C:\Python311-amd64\Scripts>systeminfo | findstr /B /C:"OS Name" /C:"OS Version" OS Name: Microsoft Windows Server 2022 Standard OS Version: 10.0.20348 N/A Build 20348 import mysql.connector import sys import platform print("OS: {} {}".format(platform.system(), platform.release())) print("Python:", format(sys.version)) driver = mysql.connector print("Driver: {} {}".format(driver.__name__, driver.__version__)) test_conn = mysql.connector.connect(user='ushastry',password='mysql123', host='**.**.com',database='sakila', use_pure=True) cur = test_conn.cursor() cur.execute('select * from sakila.actor') # The following two calls return the same data records = cur.fetchmany() print("Fetching Total ", len(records), " rows") print("Printing each row") for row in records: print("Actor Id: ", row[0]) print("First Name: ", row[1]) print("Last Name: ", row[2]) print("Last update: ", row[3]) print("\n") records1 = cur.fetchmany() print("Fetching Total ", len(records1), " rows") print("Printing each row") for row1 in records1: print("Actor Id: ", row1[0]) print("First Name: ", row1[1]) print("Last Name: ", row1[2]) print("Last update: ", row1[3]) print("\n") -- VS 2022, Python 3.11, Connector/Python 9.1.0 installed using pip OS: Windows 10 Python: 3.11.0 (main, Oct 24 2022, 18:26:48) [MSC v.1933 64 bit (AMD64)] Driver: mysql.connector 9.1.0 Fetching Total 1 rows Printing each row Actor Id: 1 First Name: PENELOPE Last Name: GUINESS Last update: 2006-02-15 04:34:33 Fetching Total 1 rows Printing each row Actor Id: 2 First Name: NICK Last Name: WAHLBERG Last update: 2006-02-15 04:34:33 Press any key to continue . . . ### pyinstaller setup C:\Python311-amd64\Scripts>pip3.11.exe --proxy http://www-proxy.us.oracle.com:80 install pyinstaller Collecting pyinstaller Using cached pyinstaller-6.11.1-py3-none-win_amd64.whl (1.3 MB) Requirement already satisfied: setuptools>=42.0.0 in c:\python311-amd64\lib\site-packages (from pyinstaller) (65.5.0) Collecting altgraph Using cached altgraph-0.17.4-py2.py3-none-any.whl (21 kB) Collecting pyinstaller-hooks-contrib>=2024.9 Using cached pyinstaller_hooks_contrib-2024.10-py3-none-any.whl (338 kB) Collecting packaging>=22.0 Using cached packaging-24.2-py3-none-any.whl (65 kB) Collecting pefile!=2024.8.26,>=2022.5.30 Using cached pefile-2023.2.7-py3-none-any.whl (71 kB) Collecting pywin32-ctypes>=0.2.1 Using cached pywin32_ctypes-0.2.3-py3-none-any.whl (30 kB) Installing collected packages: altgraph, pywin32-ctypes, pefile, packaging, pyinstaller-hooks-contrib, pyinstaller WARNING: The scripts pyi-archive_viewer.exe, pyi-bindepend.exe, pyi-grab_version.exe, pyi-makespec.exe, pyi-set_version.exe and pyinstaller.exe are installed in 'C:\Python311-amd64\Scripts' which is not on PATH. Consider adding this directory to PATH or, if you prefer to suppress this warning, use --no-warn-script-location. Successfully installed altgraph-0.17.4 packaging-24.2 pefile-2023.2.7 pyinstaller-6.11.1 pyinstaller-hooks-contrib-2024.10 pywin32-ctypes-0.2.3 ### C:\Python311-amd64\Scripts>pyinstaller.exe --onefile D:\ushastry\Connectors\Python\Bug116835\Bug116835.py 315 INFO: PyInstaller: 6.11.1, contrib hooks: 2024.10 315 INFO: Python: 3.11.0 347 INFO: Platform: Windows-10-10.0.20348-SP0 347 INFO: Python environment: C:\Python311-amd64 347 INFO: wrote C:\Python311-amd64\Scripts\Bug116835.spec 362 INFO: Module search paths (PYTHONPATH): ['C:\\Python311-amd64\\Scripts\\pyinstaller.exe', 'C:\\Python311-amd64\\python311.zip', 'C:\\Python311-amd64\\Lib', 'C:\\Python311-amd64\\DLLs', 'C:\\Python311-amd64', 'C:\\Python311-amd64\\Lib\\site-packages', 'D:\\ushastry\\Connectors\\Python\\Bug116835'] 978 INFO: checking Analysis 978 INFO: Building Analysis because Analysis-00.toc is non existent 984 INFO: Running Analysis Analysis-00.toc 984 INFO: Target bytecode optimization level: 0 984 INFO: Initializing module dependency graph... 984 INFO: Initializing module graph hook caches... 993 INFO: Analyzing base_library.zip ... 2952 INFO: Processing standard module hook 'hook-heapq.py' from 'C:\\Python311-amd64\\Lib\\site-packages\\PyInstaller\\hooks' 3046 INFO: Processing standard module hook 'hook-encodings.py' from 'C:\\Python311-amd64\\Lib\\site-packages\\PyInstaller\\hooks' 4952 INFO: Processing standard module hook 'hook-pickle.py' from 'C:\\Python311-amd64\\Lib\\site-packages\\PyInstaller\\hooks' 6671 INFO: Caching module dependency graph... 6791 INFO: Looking for Python shared library... 6807 INFO: Using Python shared library: C:\Python311-amd64\python311.dll 6807 INFO: Analyzing D:\ushastry\Connectors\Python\Bug116835\Bug116835.py 6859 INFO: Processing standard module hook 'hook-platform.py' from 'C:\\Python311-amd64\\Lib\\site-packages\\PyInstaller\\hooks' 7468 INFO: Processing module hooks (post-graph stage)... 7484 INFO: Performing binary vs. data reclassification (2 entries) 7500 INFO: Looking for ctypes DLLs 7515 INFO: Analyzing run-time hooks ... 7515 INFO: Including run-time hook 'pyi_rth_inspect.py' from 'C:\\Python311-amd64\\Lib\\site-packages\\PyInstaller\\hooks\\rthooks' 7531 INFO: Looking for dynamic libraries 7830 INFO: Extra DLL search directories (AddDllDirectory): [] 7830 INFO: Extra DLL search directories (PATH): [] 8414 INFO: Warnings written to C:\Python311-amd64\Scripts\build\Bug116835\warn-Bug116835.txt 8430 INFO: Graph cross-reference written to C:\Python311-amd64\Scripts\build\Bug116835\xref-Bug116835.html 8484 INFO: checking PYZ 8484 INFO: Building PYZ because PYZ-00.toc is non existent 8493 INFO: Building PYZ (ZlibArchive) C:\Python311-amd64\Scripts\build\Bug116835\PYZ-00.pyz 8828 INFO: Building PYZ (ZlibArchive) C:\Python311-amd64\Scripts\build\Bug116835\PYZ-00.pyz completed successfully. 8842 INFO: checking PKG 8842 INFO: Building PKG because PKG-00.toc is non existent 8842 INFO: Building PKG (CArchive) Bug116835.pkg 13079 INFO: Building PKG (CArchive) Bug116835.pkg completed successfully. 13079 INFO: Bootloader C:\Python311-amd64\Lib\site-packages\PyInstaller\bootloader\Windows-64bit-intel\run.exe 13079 INFO: checking EXE 13079 INFO: Building EXE because EXE-00.toc is non existent 13079 INFO: Building EXE from EXE-00.toc 13079 INFO: Copying bootloader EXE to C:\Python311-amd64\Scripts\dist\Bug116835.exe 13158 INFO: Copying icon to EXE 13221 INFO: Copying 0 resources to EXE 13234 INFO: Embedding manifest in EXE 13296 INFO: Appending PKG archive to EXE 13364 INFO: Fixing EXE headers 15245 INFO: Building EXE from EXE-00.toc completed successfully. -- running the exe C:\Python311-amd64\Scripts>C:\Python311-amd64\Scripts\dist\Bug116835.exe C:\Python311-amd64\Scripts>C:\Python311-amd64\Scripts\dist\Bug116835.exe OS: Windows 10 Python: 3.11.0 (main, Oct 24 2022, 18:26:48) [MSC v.1933 64 bit (AMD64)] Driver: mysql.connector 9.1.0 Fetching Total 1 rows Printing each row Actor Id: 1 First Name: PENELOPE Last Name: GUINESS Last update: 2006-02-15 04:34:33 Fetching Total 1 rows Printing each row Actor Id: 2 First Name: NICK Last Name: WAHLBERG Last update: 2006-02-15 04:34:33 C:\Python311-amd64\Scripts>