MySQL Workbench, an open-source tool, facilitates seamless connection to server databases from any computer.
Download it for free at this link: https://dev.mysql.com/downloads/workbench/
Important: Ensure successful installation by pre-installing the Visual C++ Redistributable Package version 2015-2019. The process won't proceed without this prerequisite.
Connecting to a Database Using MySQL Workbench:
-
Launch the MySQL Workbench application.
-
Select the '+' icon adjacent to MySQL connections, following the example in the provided screenshot.
-
You'll see the "Set Up a New Connection" dialog window appear. Fill up the blanks with relevant information. Use this tutorial to get started.
-
Connection Name: Assign a name to your connection.
-
Connection Method: Retain the default setting: Standard (TCP/IP).
-
Hostname: Input the IP address of the database host.
-
Port: Keep it unchanged at 3306.
-
Username: Input your control panel account username or the designated database user.
-
Password: Enter your control panel account password or the database user's password. Select "Store in Vault" before proceeding.
-
The "Store Password For Connection" window will appear. Once you've typed in your password, click OK.
-
To verify the connection's establishment, click the "Test Connection" button.
-
Upon successful connection, a message will appear with details about the connection. Click OK to proceed.
-
Press OK in the "Set up a New Connection" dialog box to establish the connection.
-
The recently created connection will be listed below MySQL connections. Click on the connection.
The database opens in the nearby window, revealing its tables.
