When you use MySQL Shell with extra Python plugins (like these available on GitHub), sometimes, you could need extra Python modules.
Some of my plugins require
prettytable for example.
MySQL 8.0.26 uses embedded Python 3.9 and if your system doesn’t have that version (like Oracle Linux 8), you won’t be able to install the missing module.
So how could we install the missing modules ? The easiest method is to use PIP, but if you don’t have PIP for Python 3.9 installed on the system, this will be more complicated…. not really !
This how to install PIP in MySQL Shell:
wget https://bootstrap.pypa.io/get-pip.py mysqlsh --py -f get-pip.py
And now you can use PIP to install extra modules:
mysqlsh --pym pip install --user prettytable
When you know how to do it, it’s very easy.
Enjoy MySQL and MySQL Shell !