Are you looking to manage your databases with advanced tools like MySQL Workbench?
You can connect to a hosted database using Remote MySQL Access. While the integrated phpMyAdmin tool is available, using remote SQL can provide you with additional features and robustness for efficient database management.
Configuring Remote MySQL Access
Log in to your Umbrella Host client area.
Navigate to Manage Hosting and select the package where your desired database is located.
Click on Options and then Login To Hosting to access the hosting package overview.
Scroll down to the Web Tools section and click on the Remote MySQL Access Icon.
Under Add Access Host, choose the database user you want to connect to remotely from the dropdown menu.
Enter the IP address from which you'll be connecting. The current IP address is added automatically, but you can customise it or use % as a wildcard to whitelist all IP addresses.
Click Add Host
Your remote MySQL credentials have now been created. Remember, for remote connections, always use mysql.gb.stackcp.com as the hostname, not the standard database hostname.
Connecting with MySQL Workbench
Open MySQL Workbench and go to the Database menu.
Select Manage Connections and provide a name for your connection in the 'Connection Name' field.
In the Hostname field, enter "mysql.gb.stackcp.com."
Enter the port number generated on the Remote SQL Access page in the hosting control panel.
The username is the database name, which can also be found on the same hosting control panel page.
Add the database password to MySQL Workbench by clicking Store in Vault.
Click Test Connection to ensure everything is configured correctly. You should see a success message.
