Zone of Development

by Damiano Abballe

Category: MySQL

Python – How to connect to MySQL

In this post, we will see how to connect a Python application with the MySQL Db called “DbManagerUser”, created in the post: MySQL – How to create a DB. First of all, in order to install the MySQL connector for Python, we run the command pip install mysql-connector-python. Then, we open Visual Studio Code and […]

Read More

MySQL – How to create a DB

In this post, we will see how to create a DB in MySQL, using MySQLWorkbench.First of all, we open MySQLWorkbench, select our MySQL instance and we insert the password: [Create DB]We push on the “new schema” icon, insert the Db name “DbManagerUser” and then we push the Apply button: [Create Tables]We select the new schema […]

Read More

MySQL – How to install on Win

In this post, we will see how to install and configure MySQL on Windows.We open a browser, go to https://dev.mysql.com/downloads/mysql/ and we download the latest version of MySQL (we select MySQL Installer MSI): Then, we double click on the MSI file for starting the installation: Now, we select the Custom installation: and then, we select […]

Read More

MySQL – How to install on macOS

From Wikipedia:“MySQL is an open-source relational database management system (RDBMS).Its name is a combination of “My”, the name of co-founder Michael Widenius’s daughter, and SQL, the abbreviation for Structured Query Language.MySQL is free and open-source software under the terms of the GNU General Public License, and is also available under a variety of proprietary licenses. MySQL was owned and sponsored by the Swedish company MySQL AB, which was bought […]

Read More