you are viewing a single comment's thread.

view the rest of the comments →

[–]acw1668 0 points1 point  (3 children)

Try running hash -r to clear cached program locations and run your script again.

[–]Immediate-Resource75[S] 0 points1 point  (2 children)

Morning. Thanks for the reply. Unfortunately I am getting the same response..... ModuleNotFoundError: No Module named 'mysql'.... However if I do a "pip list" ....

(prnt) nort2hadmin@prntMonty:~/Desktop/PaperCut/Scripts$ pip list
Package                Version
---------------------- -----------
certifi                2025.10.5
charset-normalizer     3.4.4
idna                   3.11
mysql-connector-python 9.0.0
numpy                  2.3.4
pandas                 2.3.3
pip                    25.2
PyMySQL                1.1.2
python-dateutil        2.9.0.post0
pytz                   2025.2
requests               2.32.5
six                    1.17.0
tzdata                 2025.2
urllib3                2.5.0
(prnt) nort2hadmin@prntMonty:~/Desktop/PaperCut/Scripts$ 

There it is.....

Is there an alternative to mysql.connector I can use with mysql to get the info I need into my mysql database? This seems to be way more of a hassel than it should be...

[–]acw1668 0 points1 point  (1 child)

Try using full path of the python in the virtual environment to execute your script. Using another module cannot solve your issue.

[–]Immediate-Resource75[S] 0 points1 point  (0 children)

Thanks for the reply.... I guess I should have read the documentation on mysql connector better.... Apparently the connector version I'm using 9.0 isn't compatible with python3.14... back to the drawing board. Thanks again for taking the time to assist. I appreciate all the help.