A Blog Of Random Coding Techniques & Experiments Robert Askam

Connecting MySQL Workbench to XAMPP Post Connecting MySQL Workbench to XAMPP 1 year ago

Trying to navigate through the XAMPP phpmyadmin page can be difficult when you have a large database.
To make this easier download MySQL Workbench and install.
Go to localhost/phpmyadmin and on the right under the section MySQL you have the login details.
Open up a new connection on Workbench and set
Connection Name: [choose a name]
Connection Method: Standard (TCP/IP)

In the parameters tab:
Hostname: localhost
Port: 3306
Username: root
Password: leave blank

Click ok and you should now be connected. If you have any connection errors ensure there match with the credentials in you phpmyadmin tab you opened earlier.