First of all, pip is made for Python2.x and pip3 is made for Python3.x. Thus you need to select wisely which version of module you are installing.
Installing through pip3 Python3.x
$ sudo pip3 install mysql-connector $ sudo pip3 install mysql-connector-python-rf $ pip3 install --upgrade --force pip $ python3 -m pip install some_module $ pip3 -V
Installing through pip for Python2.x
$ sudo pip install mysql-connector $ sudo pip install mysql-connector-python-rf $ python2 -m pip install some_module $ pip -V
You must set new password first time you login to mysql else it would through following erros.
Rajeshs-MacBook-Pro:bin rajeshkumar$ /usr/local/mysql/bin/mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 6 Server version: 5.7.28 Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved. 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> show databases; ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
How to set up your password for the first time?
$ /usr/local/mysql/bin/mysql -u root -p SET PASSWORD = PASSWORD('your_new_password'); or ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass';