{"id":41574,"date":"2024-05-17T13:07:36","date_gmt":"2024-05-17T13:07:36","guid":{"rendered":"https:\/\/accuweb.cloud\/resource\/?post_type=faq&p=41574"},"modified":"2026-02-19T05:30:05","modified_gmt":"2026-02-19T05:30:05","slug":"python-connection-to-mysql-mariadb","status":"publish","type":"faq","link":"https:\/\/accuweb.cloud\/resource\/articles\/python-connection-to-mysql-mariadb","title":{"rendered":"Python Application Connection to MySQL\/MariaDB\/Percona"},"content":{"rendered":"

Python Application Connection to MySQL\/MariaDB\/Percona<\/h2>\n

When an open-source SQL database is needed, developers worldwide are quite fond of MySQL, MariaDB, and Percona. We’ll walk you through connecting your Python application,<\/a> hosted on the platform, to MySQL<\/a> DB servers in this instruction.<\/p>\n

Step 1.<\/strong> Access the platform dashboard and establish a new environment with MySQL<\/strong> (or MariaDB) and Python servers.<\/strong><\/p>\n

\"New<\/a><\/p>\n

Step 2.<\/strong> Once the environment has been created, use SSH Gate to access your application server, for example, by clicking the Web SSH button.<\/strong><\/p>\n

\"Web<\/a><\/p>\n

The relevant tab will open with a terminal emulator that has the SSH connection to your node established automatically.<\/p>\n

Step 3.<\/strong> Next, use the following command to install a MySQL<\/a> connector for Python (it also functions with MariaDB):<\/p>\n

<\/div>\n
\r\npip install mysql-connector==2.2.9<\/code><\/pre>\n
<\/div>\n
\"Install<\/a><\/p>\n
Step 4.<\/strong> Next, let\u2019s create a simple Python<\/a> script to establish a database connection. You can use any preferable text editor for this task, as well as any filename with the .py extension<\/strong> (e.g. vim script.py).<\/p>\n
Here, you need to adjust the connection string (all the required information is provided within the email for your MySQL \/ MariaDB<\/a> node):<\/p>\n