Guide to Installing MySQL Server and MySQL Workbench on Windows 10/11 [ 2024 Update ]: A Complete How-To.

Learn how to install MySQL server & workbench on Windows and write queries to create tables and databases. Follow along for step-by-step instructions and start coding! MySQL for Windows, it’s like getting the keys to the coding kingdom. Just follow the steps and you’ll be creating tables and inserting data like a pro in no time!πŸ’»πŸ”‘ #GeekyScript #MySQLOnWindows

πŸ› οΈ Installation Process

Today, in this video tutorial, we will cover the step-by-step process to install MySQL server and MySQL Workbench on a Windows system. By the end of this video, you will gain a deep understanding of how to install and operate MySQL. If you encounter any issues during the process, feel free to leave a comment and I will be happy to assist you.

πŸ“₯ Downloading MySQL

To begin the installation, open a new tab in your web browser and type "MySQL download" in the search bar. Click on the MySQL Downloads link, which will redirect you to the official MySQL website. Scroll down and select the MySQL Installer for Windows. You can find the direct download link in the description below.

Product TypeVersion
MySQL Server8.2.35

βš™οΈ Custom Installation

Upon launching the MySQL installer, select the custom installation option and choose MySQL Server along with MySQL Workbench. Click on "Execute" to begin the installation process.

"Select the components you want to install based on your preferences and requirements."

πŸ–₯️ Configuration

After the installation is complete, the configuration setup will prompt you to set a password and verify the Windows service name. It is advisable to use a strong password for added security.

Key Takeaways:

  • Remember the TCP/IP port number for future communication with MySQL server.
  • The Windows service name will be "MySQL" and it will automatically start during system startup.

❗ Executing the Installation

After configuring the settings, click on "Execute" to start the installation process. Once the configuration is successful, click on "Finish" to launch MySQL Workbench.

✍️ Using MySQL Workbench

In the MySQL Workbench interface, you can create databases, tables, and execute queries. The tutorial demonstrates the process of creating a database, table, and inserting data into the table. It also covers fetching data from the table to provide a comprehensive understanding of the MySQL environment on Windows.

Congratulations! You have successfully installed MySQL Server and MySQL Workbench on your Windows system. I hope this video tutorial has been helpful in enhancing your MySQL knowledge. Don’t forget to like, share, and subscribe for more informative videos.

For more MySQL related content, consider subscribing to our channels:

  • Geeky Syntax: Programming and Coding videos
  • Geeky Script Vlogs: Vlogging Channel from Kashmir

Thank you for watching! 🌟

About the Author

About the Channel:

Share the Post: