In this article, I will clarify the bit by bit establishment interaction of MySQL data set worker 8.0.19. MySQL is open-source, cross-stage social information base administration worker created by Swedish organization "MySQL AB" and later obtained by Oracle partnership. MySQL is offered as an open-source MySQL people group worker release and venture worker version. In this article, I will introduce the MySQL Community worker version.
Download and install MySQL database server
You can download the MySQL community server from this location. Once the installer has been downloaded, double-click the setup file to start the installation process. On the Choosing a Setup Type page, you can see four installation options.
Developer default: If you want to create a development machine, you can use this option. It installs the components which are required for application development, e.g., MySQL Server, MySQL Shell, MySQL connectors, MySQL
Server Only: If you want to create a standalone database server with specific components, you can use this option
Full: If you want to install MySQL Server with its all components, then you can use this option
Custom: If your requirements are limited to the few components, you can use this option
We are going to install MySQL Server with all components; hence, choose “Full” and click on Next.
On the Installation screen, you can see the list of the MySQL products/software that are going to be installed on my workstation. Review the list and click on Execute.
On Type and Networking screen, we can configure the following:
The type of MySQL configuration.
The type of MySQL configuration is a predefined set of configuration parameter that determines how much resources should be allocated to the MySQL Services. You have three configuration options:
- Development Computer: This configuration uses a minimal amount of the resources to MySQL Service
- Server Computer: This configuration uses a minimal amount of resources. This option is suitable when we are installing database servers and web servers on the same machine. The configuration allocates an average amount of resources to MySQL Service
- Dedicated Computer: This option is used when we have created a dedicated MySQL Server. The configuration allocates a high amount of resources to MySQL Service
We would configure the server with minimal resources hence select “Development computer” from the Config Type drop-down box.
Network Connectivity
In this section, we can control how clients can connect to MySQL databases. We can use TCP/IP protocol or Named Pipe or Shared Memory. If you want to configure Named Pipe / Shared Memory, we must provide the Pipe Name and Memory Name. You can also specify the default port to connect to the database server. You can also choose to allow the port number specified in Port textbox in the firewall. See the following image:
Install the sample database
If you have chosen to install all the components of MySQL Server (Full Setup Type), MySQL installer moves to Sample and Example screen. On this screen, provide username and password of the user that has root/sysadmin privileges and click on Check. If the connection establishes successfully, click on next. See the following image:
Once the installation completes, you can copy the installation logs on the clipboard to review it later. Moreover, if you want to start exploring MySQL straight away, then you can select “Start MySQL workbench after Setup” and “Start MySQL Shell after Setup” and click on Finish. See the following image:
Connect to MySQL Server
Once the installation completes, let us connect to the server and execute the first MySQL Query. Open MySQL workbench. Just like SQL Server management studio, MySQL workbench is the development tool which is used to querying the database and create database objects.
On MySQL workbench welcome screen, you can see the list of MySQL connections. We have not configured multiple connections; hence you can see “Local instance MySQL80.” Click on it to open the new query editor window.
.gif)
0 Comments