How To Install MySQL 8 0 34 Server And Workbench Latest Version On Windows 10 [2023]

Published: 19 August 2023
on channel: techfixvalley
137
4

Effortless MySQL 8.0.34 Server and Workbench Installation on Windows 10

Ready to dive into the world of MySQL? Let's walk through the simple steps to seamlessly install MySQL 8.0.34 Server and the latest Workbench version on your Windows 10 system.

Step 1: Visit MySQL Official Website - MYSQL Link- https://www.mysql.com/

1. Open your preferred web browser.
2. Type "MySQL" in the search bar and hit Enter.
3. Visit the official MySQL website by clicking on the relevant link.

Step 2: Downloading MySQL

1. On the MySQL website, navigate to the "Downloads" section.
2. Look for "MYSQL Community (GPL) Downloads" and click on it.
3. Choose "MYSQL Installer for Windows."

Step 3: Installation Process

1. Once the installer file is downloaded, run it.
2. Choose the "Custom" installation option.
3. Select the components you want to install:
- MYSQL Server
- MYSQL Workbench

Step 4: Configuring MYSQL Server

1. Click "Next" to proceed.
2. Choose "MYSQL Server" and then select "MYSQL Server 8.0."
3. Pick the 64-bit version (x64) that suits your system.

Step 5: Configuring MYSQL Workbench

1. Proceed with the installation.
2. Select "MYSQL Workbench" and then choose "MYSQL Workbench 8.0."
3. Again, choose the 64-bit version (x64) that matches your system.

Step 6: Completing the Installation

1. Follow the on-screen instructions and click "Next."
2. Execute the installation process.
3. Ensure "Use Strong Password Encryption" is selected.
4. Set a strong password for the root user and confirm it.
5. Continue with the installation and wait for it to finish.

Step 7: Adding MYSQL to Path

1. Minimize all windows and navigate to the installed directory.
2. Copy the path from the address bar.

Step 8: Setting Up Environment Variables

1. Search for "Environment Variables" in the Windows search bar and access it.
2. In the System Properties window, click on the "Environment Variables" button.
3. In the "System Variables" section, locate and select "Path," then click "Edit."
4. Add a new entry and paste the copied path, then click "OK" to close the windows.

Step 9: Testing the Installation

1. Open Command Prompt (CMD) by searching for it in the Windows search bar.
2. Type "mysql --version" to verify the MySQL version.
3. Type "mysql -u root -p" and enter the password you set during installation.
4. Run "show databases;" to confirm the successful installation.

Congratulations! You've successfully installed MySQL 8.0.34 Server and Workbench on your Windows 10 system. You're now equipped to explore the world of database management and SQL development.

If you found this guide helpful, consider liking, subscribing, and sharing it with others who might find it useful. Enjoy your MySQL journey!

Keywords: MySQL installation, MySQL Server 8.0.34, Workbench installation, Windows 10, step-by-step guide, official download link, environment variables, testing installation, database management, root password, SQL development, software installation.

Contact Us
Instagram:   / techfixvalley  
Twitter:   / techfixvalley  


Watch video How To Install MySQL 8 0 34 Server And Workbench Latest Version On Windows 10 [2023] online without registration, duration hours minute second in high quality. This video was added by user techfixvalley 19 August 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 13 once and liked it people.