In centOS8, import MySQL connector in Python( import mysql.connector) issue
I start to use Python3 to do some code recently. I google and found some post to guide me to install MySQL connector in Python to connect to MySQL.
I login centOS8 as root , and below commands to install and check, it looks ok. [root@mySQLDB2 mypy]# pip3 install mysql-connector-python [root@mySQLDB2 mypy]# pip3 show mysql-connector-python
But when I manually to check if I can import it in Python , It show error as below:
[root@mySQLDB2 ~]# python3 Python 3.6.8 (default, Mar 19 2021, 05:13:41) [GCC 8.4.1 20200928 (Red Hat 8.4.1-1)] on linux Type "help", "copyright", "credits" or "license" for more information.
import mysql.connector Traceback (most recent call last): File "", line 1, in File "/usr/local/lib64/python3.6/site-packages/mysql/connector/init.py", line 53, in from .connection import MySQLConnection File "/usr/local/lib64/python3.6/site-packages/mysql/connector/connection.py", line 35, in import platform File "/usr/lib64/python3.6/platform.py", line 116, in import sys, os, re, subprocess File "/usr/lib64/python3.6/subprocess.py", line 137, in import select File "/root/select.py", line 2, in from mysql.connector import Error ImportError: cannot import name 'Error' exit() [root@mySQLDB2 ~]#
I did search and read this issue for past few days and tried different ways , the problem still there.
I install Python in centOS8 as root running"[root@mySQLDB2 ~]# yum install python3".
Any one experienced this? Thanks for any imput.