Installing the MySQL Server
00:00 In the previous lesson, you learned that MySQL is a relational database management system that enables users to store, manage, and retrieve structured data efficiently.
00:12 This lesson will guide you how to set up a local server on your computer. It is highlighted in orange color in the slide. Also, it’ll introduce you to MySQL Workbench software.
00:25 By the end of this lesson, you’ll be ready to manage data and to perform administrative tasks using MySQL Workbench user interface.
00:36 As you may already know, these localhost database servers are often used for developing software. They’re designed to share the same data among different users on different computers.
00:53 Firstly, let’s download a MySQL server that is suitable for your operating system from the following website: dev.mysql.com/downloads/mysql. Make sure that you’re selecting the latest version for the operating system that you are using.
01:14 For Microsoft Windows, you can download the server from a different website, dev.mysql.com/downloads/installer.
01:28 This website contains wizard-like installation tools that automatically install the software for a 32-bit Windows OS. For a 64-bit system type, I recommend that you select the installer with MSI extension available on dev.mysql.com/downloads/mysql.
01:55 Another least preferred option is a zip archive that requires manual installation. Next, make sure that you select the latest version of the installer from the dropdown menu.
02:12 If you are new to the installation process, I’ll advise you to open dev.mysql.com/doc website. Click on MySQL Server, followed by Installing MySQL, and follow a paragraph that is relevant to your operating system.
02:32 If you are a Microsoft Windows user, it’s important to keep in mind that you have to select the correct version in the upper right box. It’ll then take you to the paragraph 2.3.3 on MySQL Installer for Windows.
02:53 During the installation process, that takes care of itself. It is important to remember that your administrator name is root and your password. You will then use these credentials for authorized access to the MySQL database from within your Python code.
03:13 It is also helpful to set up tools like MySQL Workbench. Going back to the downloads site at dev.mysql.com/downloads, click on MySQL Workbench. This link will take you to the same user interface that you had when downloading MySQL server.
03:38 From the dropdown menu list, you can grab a software package suitable for your operating system.
03:48 MySQL Workbench is very useful as it’ll allow you to perform administrative tasks such as root or other user account management.
04:00 It will allow you to perform data import and data export to check on the status of your server, and of course, we would like to see it running, To create a new database and to write and to execute SQL queries, make sure that you have MySQL Server and MySQL Workbench installed on your computer.
04:25 You will use the MySQL Workbench throughout this course to verify that certain database operations that you coded in Python worked. I encourage you to browse MySQL Workbench functionality and to get more comfortable with its user interface.
Become a Member to join the conversation.