If you're a UK2 customer looking to manage your databases with advanced tools like MySQL Workbench, this article will guide you through the process of connecting to a UK2-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.
Login to StackCP by following this guide
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 customize 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.
No worries, Our experts are here to help.