MySql

This section shows various MySQL tutorials.

Installation

Windows

  1. Download mysql-installer-community-8.0.23.0.msi from https://dev.mysql.com/downloads/installer/

  2. Download MySql image::mysql/windows/download-mysql.jpg[600,600]

  3. Open the installed file and in the installer select Developer Default and click on next

    600
    Figure 1. Setup MySql

  4. In the check requirements tab, click on execute

    600
    Figure 2. Download MySql Requirements

  5. After downloading the required requirements, press on next to install it.

    600
    Figure 3. Install MySql Requirements

  6. Now press on execute to install the required products

    600
    Figure 4. Install MySql Products

  7. Once the installation is complete click next.

    600
    Figure 5. Complete installation

  8. In the Product Configuration press on next to input the configurations, and you will get the following screen:

    Leave the default configurations for the following screens (Type and Networking and Authentication Method).
    600
    Figure 6. Type and Networking
    600
    Figure 7. Authentication Method

  9. In the Account and Roles tab, enter a password for MySQL server and press next.

    If you need to connect to the database server from other machine, press on add Add User and give it a user name and password with the default selected configurations.
    600
    Figure 8. Account And Roles

  10. Once finished setting up the Accounts and Roles, the Windows Service tab will open and you can change the MySQL service, its recommended to leave the default configurations.

    600
    Figure 9. Windows Service

  11. Finally we want to apply the configurations that we configured, so in the Apply Configuration tab, press on execute then finish

    600
    Figure 10. Execute Config

  12. After completing the configurations, it will take us back to the product configuration tab in the main installation window, press on Next to finish the installation.

  13. A new window should pop-up to test the Server connection, enter your username and password then click on Check, if the connection was successful you should see a green tag in the status column saying Connection Succeeded, now press on next

    600
    Figure 11. Execute Config

  14. Now we have the service up, running and tested we can press on execute in the Apply Configuration tab to execute all the changes, then press on finish

  15. This will take you back to the main installation window with everything set up for you, so to finish the installation press on next then finish.

  16. Now you have MySQL ready to be used.

MacOS

  1. Go to https://dev.mysql.com/downloads/mysql/

  2. Select Operating System as macOS

  3. Choose macOS 10.15 (x86, 64-bit), DMG Archive

    600
    Figure 12. Download MySql Mac

  4. Open the installed file, and double click on the installation package to install it

    600
    Figure 13. MySql Mac Installer

  5. The installer wizard should open

    600
    Figure 14. MySql Mac Installer Wizard

  6. Press on continue to agree on the license

  7. Specify the desired location or leave it as default in the Installation Type tab then press on Install

    600
    Figure 15. MySql Installation Type Mac

  8. In the configuration tab choose the Password Encryption, we are going to use Strong password encryption.

    600
    Figure 16. MySql Configuration Mac

  9. Press on next inside the dialog to set the password, then press on finish

    600
    Figure 17. MySql Set Password Mac

  10. Now you have MySQL ready to be used.

Ubuntu

  1. Update the list of available packages then install the newer versions of the packages

    apt-get update && apt-get upgrade

  2. Install MySQL

    sudo apt install mysql-server

  3. Configure MySQL Security

    sudo mysql_secure_installation

  4. This will ask you if you want to use VALIDATE PASSWORD COMPONENT, which is used to test your password and improve security. Type (Y) and if you want to use and (N) otherwise

  5. Enter a password for the root user

  6. Re-enter it

  7. press (Y) if you confirm that you want to proceed with the password

  8. Run it using the following command

    sudo mysql -u root -p

  9. Enter your root user password and press enter to access the server