How to install MySQl for Python on Linux?

Applications are being developed on Python nowadays. Developers usually prefer the operating system platform based on their convenience. Usually, developers are used to the command line terminal, Linux is the platform for them.

Developing applications in Python has advantages over handling complexity in a simpler manner. There are scenarios where Python applications need connection with MySQL.

To establish connectivity on the Linux platform, MySQL should be installed and set up properly. 

When the application logic is built in Python and the data is stored in MySQL, Python applications need connectivity to pull and push data to and from the MySQL database.

Get MySQL Installed on Linux [Step by Step]

For the purpose of installation we have taken Ubuntu as an Linux distro. Most of the steps would be same for any Linux distro except few commands. Please comment below if you want me to write a tutorial for any specific Linux distribution.

1. The terminal window on Linux needs to be open.
2. Enter and execute the command – Alternatively you can download it from https://dev.mysql.com/downloads/mysql/, from operating system drop-down select Linux

sudo apt install mysql-server

3. The process of connecting to the MySQL downloadable is initiated.

4. Make sure there is enough hard disk space (245 MB) as mentioned before starting the installation process. 

5. Type y to start connecting to the downloadable.
6. The downloading and installation process starts.
7. Once completed, you shall see the “done!” text.

8. To check MySQL installed successfully, enter and run the below command.

mysql --version

9. The version shall be displayed as below.

10. For security purposes, set the password to access MySQL. Use the following command for setting up the password.

sudo mysql_secure_installation

11.  Press Y to continue.

12. Setup the level of password to be set. A screen asking you the level shall be shown as below.

13. Press 0 (LOW) for easy to remember the password. 

14. The next is to enter the new password and re-enter the same password to be set.
15. Press Y to continue.
16. Again, press Y where it is asking the user to remove anonymous users.
17. To remove the test database and privileges, keep pressing Y on the prompts.

18. You are all set with MySQL installed.

Also read:

• How to install Python on Chromebook
• How to install Kali Linux on Mac
• How t install MySQL on Mac for Python
• How to install MySQL on Windows for Python
• Best Linux Distros for gaming
• How to replace Chrome OS with Linux
• Debian vs Ubuntu
• How to install Python IDLE in Linux

Install MySQL Connector for Python

Pip is a package manager that allows the user to install Python packages easily. The steps to install pip and then MySQL connector are stated here.

1. Start the terminal window.
2. Enter and run the command :

sudo apt -get install python3 -pip

3. Make sure that the system has enough space to install pip. Press Y to proceed.

4. Post confirmation, download of pip package manager starts.

5. Once done, the unpacking process starts.

6. Once done, the installation process completes and the command prompt reverts with $.

7. The next step is to install MySQL connector through pip.
8. Enter the command – 

pip install mysql-connector -python

9. ENTER to execute the command. The process downloading the package starts.

10. Installation starts and once completed, the user gets to see a success message.

11. Verify that MySQL works with Python. To do so:
    • Create the test.py file in the code editor. 
    • Enter the text below in the .py file.

import mysql.connectorprint(“Connector version : {0}” .format(mysql.connector.__version__))

12. On the terminal, run this command:

python test.py

13. You shall see the output as below.

Connector version : 8.0.17

Takeaway

After performing all the steps above, the developer will be easily able to connect to MySQL and fetch the data in the Python application and push data to MySQL using the MySQL connector.