Using MySQL client applications
MySQL client tools help you access and manage your MySQL databases. One of the main tools is MySQL Workbench—a free GUI application available for Windows, macOS, Linux, and other platforms.
Connecting to MySQL With MySQL Workbench
Section titled “Connecting to MySQL With MySQL Workbench”There are two main connection methods you can use:
-
Direct Connection
Section titled “Direct Connection” -
SSH Connection (Secure Tunnel)
Section titled “SSH Connection (Secure Tunnel)”
Direct Connection
Section titled “Direct Connection”Follow these steps to set up a direct connection:
-
Open MySQL Workbench.
-
On the main screen, click the + icon beside MySQL Connections.
-
Enter a name for the connection.
-
Select Standard (TCP/IP) as the connection method.
-
In Hostname, type example.com (replace with your domain).
-
Ensure the port is 3306.
-
Enter your username:
- Your ruachost.com (cPanel) username (full access), or
- A database-specific MySQL user created in cPanel.
-
(Optional) Enter the Default Schema (database name).
-
Click Test Connection and enter the password.
-
Select Save password in keychain if needed.
-
Click OK and continue if you see a version warning.
-
Save the connection and open it from the workspace.
Important Before Using Direct Connection
Section titled “Important Before Using Direct Connection”- Open a ticket on https://dashboard.ruachost.com requesting inbound access to port 3306.
- Add your IP under Remote MySQL in cPanel.
SSH Connection
Section titled “SSH Connection”To securely connect through an SSH tunnel:
- Open MySQL Workbench.
- Click the + beside MySQL Connections.
- Type a name for the connection.
- Choose Standard (TCP/IP) over SSH.
- Enter example.com:22 under SSH Hostname (confirm correct SSH port; some servers use 7822).
- Enter your ruachost.com (cPanel) username as SSH Username.
- Use localhost as the MySQL Hostname.
- Keep MySQL port as 3306.
- Enter your MySQL username (cPanel user or database-specific user).
- Click Test Connection → enter cPanel password.
- Enter MySQL user password when prompted.
- Save passwords if desired.
- Save the connection and open it to work with your databases.
More Information
Section titled “More Information”Download MySQL Workbench and documentation here:
http://dev.mysql.com/downloads/tools/workbench