Connecting MySQL Workbench to XAMPP

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.