Tag Archives: MySQL

Python – How to connect to MySQL

By | 05/02/2020

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

By | 21/01/2020

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 DBWe push on the “new schema” icon, insert the Db name “DbManagerUser” and then we push the Apply button: CREATE TABLESWe select the new schema… Read More »

MySQL – How to install on Win

By | 17/01/2020

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

By | 10/01/2020

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 »