mySQL setup (Workbench)
Installation guide
Download mySQL Workbench
- Google to mySQL Workbench.
- Select the mySQL website (Download).
- Download the smaller version underneath “Other Downloads” version 8.0.36.
*XAMPP is available for several operating systems, but for this one course, Windows 10/11 is recommended
- Press “No thanks, just start my download.” to avoid logging in.
Installeer mySQL Workbench
- Open the executable.
- Choose the directory where mySQL workbench will be installed, then click next.
- Choose a complete installation, then click next.
- Click Install to start the actual installation.
- Wait for the installation to complete.
First use of mySQL Workbench
- Open mySQL Workbench.
- Open XAMPP and Start the MySQL module.
- Allow connections to be made from a private network to MySQL
- Add a connection in MySQL Workbench by clicking the “+”.
- Connect to localhost.
- Connection Name: localhost
- Hostname: 127.0.0.1 | localhost
- Port: 3306
- Test the connection.
- If the XAMPP mySQL server is not running correctly, you will receive the following error message:
-
- If the XAMPP mySQL server is running correctly you will receive the following warning:
-
- Click “Continue Anyway”.