Wednesday, January 18, 2023

Connecting MySQL Workbench to XAMPP

 Robert Askam in Blog

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.

No comments:

Post a Comment