Installation

All downloads for MySQL are located at MySQL Downloads. Pick the version number of MySQL Community Server which is required along with the platform you will be running it on.

Installing MySQL on Windows

In this tutorial, we are installing the latest version of MySQL (8.0.34) on Windows 11. Follow the given steps to do so −

Step 1: Firstly, choose the MySQL version and operating system. Then, we download the desired MSI installer on your system by clicking the ‘Download’ button shown in the image below. This installer is suitable for both 32-bit and 64-bit systems.

MySQL Installation Page

Step 2: Then, we will be redirected to another file download page. Here, ignore the prompts asking to log in or sign up and directly start downloading by clicking on the link as shown in the image.

MySQL Begin Installation

Step 3: Once the installer is downloaded, run it to start the MySQL installation.

Step 4: Now, we can see the installer community window, asking to choose a Setup type for our MySQL products. Choose Custom and click Next to decide what products we want to actually install.

MySQL Setup Type

Step 5: In the next step, select MySQL Server, MySQL Workbench, MySQL Shell (all latest versions) to be installed. We can also choose more products available as per necessity. Click Next.

MySQL Select Products

Step 6: The installation process will now begin. However, path conflicts might arise if there exists a path directory with the same name. After the installation is done, click Next.

MySQL Installation

Step 7: In this step, we will be asked to set Type and Networking of MySQL. Unless there is any particular change we want to make, it is recommended to keep the settings as they are, and click Next.

MySQL Type and Networking

Step 8: Then, we need to set the Authentication method to access MySQL root user. So, choose the strong password encryption method (as it is recommended) and click Next.

MySQL Authentication Method

Step 9: Set a password for the root account. This password must always be used to log into the root account in every session. After setting password, click Next.

MySQL Root Password

Step 10: In this step, MySQL Server Instance will be configured as a Windows Service. The default name will be set as “MySQL80”, which can be changed if needed. Click Next.

MySQL Windows Service

Step 11: Now, set the file permissions as required and click Next.

MySQL Server File Permissions

Step 12: As shown in the image below, the specified configuration steps will be applied on clicking Execute.

MySQL Apply Configuration

Once it is completed, click Finish. The next window will display the products on which the configuration is applied. Click Next to finish the installation.

MySQL Product Configuration

Step 12: The installation is now complete. Uncheck the options asking to start MySQL Workbench and Shell after setup, so that they will not run after setup. Click Finish.

MySQL Installation Complete

The MySQL Server is now installed in the Windows Operating System. We can now access it via the Command Prompt or the UI products we installed with it (Shell and Workbench).

Installing MySQL on Linux/UNIX

The recommended way to install MySQL on a Linux system is via RPM. MySQL AB makes the following RPMs available for download on its website −

  • MySQL − The MySQL database server manages the databases and tables, controls user access and processes the SQL queries.
  • MySQL-client − MySQL client programs, which make it possible to connect to and interact with the server.
  • MySQL-devel − Libraries and header files that come in handy when compiling other programs that use MySQL.
  • MySQL-shared − Shared libraries for the MySQL client.
  • MySQL-bench − Benchmark and performance testing tools for the MySQL database server.

The MySQL RPMs listed here are all built on a SuSE Linux system, but they will usually work on other Linux variants with no difficulty.

Now, you will need to adhere to the steps given below, to proceed with the installation −

  • Login to the system using the root user.
  • Switch to the directory containing the RPMs.
  • Install the MySQL database server by executing the following command. Remember to replace the filename in italics with the file name of your RPM.
[root@host]# rpm -i MySQL-5.0.9-0.i386.rpm

The above command takes care of installing the MySQL server, creating a user of MySQL, creating necessary configuration and starting the MySQL server automatically.

You can find all the MySQL related binaries in /usr/bin and /usr/sbin. All the tables and databases will be created in the /var/lib/mysql directory.

The following code box has an optional but recommended step to install the remaining RPMs in the same manner −

[root@host]# rpm -i MySQL-client-5.0.9-0.i386.rpm [root@host]# rpm -i MySQL-devel-5.0.9-0.i386.rpm [root@host]# rpm -i MySQL-shared-5.0.9-0.i386.rpm [root@host]# rpm -i MySQL-bench-5.0.9-0.i386.rpm

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *