MySQL Installation Step by Step Guide

MySQL Installation Step by Step Guide

Published June 25, 2023

---

• MySQL Installation Step by Step Guide

MySQL Installation Step by Step Guide

1. Visit mysql.com to download mysql installer

2. Once downloaded, double click on installer file to run the mysql installer. I have already installed MySQL Workbench so it’s showing there.

3. Click Add.. to add MySQL.

4. In Available Products Select MySQL Server 8.0.33 - X64 or the version you have downloaded and click right arrow to move it to Products to be installed list then click Next >

5. Click Execute on installation screen.

6. Once installation done a green check mark will arrow beside MySQL Server 8.0.33 and status will show complete. Click Next >

7. Now Product Configuration Wizard screen will appear. Click Next >

8. On Type and Networking Screen we will with default options. Default port is 3306.

9. On Authentication Method use default option Use Strong Password Encryption for Authentication (RECOMMENDED). Click Next >

10. On Accounts and Roles enter root password. Enter the same password.

    1. MySQL Root Password: 123456
    2. Repear Password: 123456

    Using the strong password is recommended but as I am on my development machine I am using simple password which is easy to remember.

11. Now click Add User to add one more user (it’s optional).

12. MySQL User Account

    1. User Name: webmastercampus
    2. Host: <All Host (%)>
    3. Role: DB Admin
    4. Password: 123456
    5. Confirm Password: 123456

    Click Ok

13. On Windows Service screen we will go with default options.

    1. Windows Service Name: MySQL80

    Click Next

14. On Server File Permissions Use default option

    1. Yes, grant full access to the user running the Windows Service (if applicable) and the administratora group only. Other users and groups will not have access.

    Click Next

15. On Apply Configuration Click Exectute to setup all selected configuration so far we have done.

16. Once configuration done it will show green check mark on all configuration steps.

    Click Finish

17. On Product Configuration screen click Next.

18. On Installation Complete Screen Click Finish.

19. Now you can close the MySQL installer screen.

20. Now on windows click on Cortana Search and type Mysql.
    1. It will show you MySQL 8.0 Command Line Client option.
    2. Click on Run or Run as Administrator if you have rights.
    3. A Command Prompt will appear.

21. Enter the password 123456

22. MySQL is ready to run with root level access.

23. Type SELECT VERSION();. It will display the MySQL Version.

24. Type SELECT user from mysql.user;. It will display all user in MySQL database because you are login with root user which have DB Admin role.

25. Type SHOW databases;. It will display all available databases.