MySQL User Management
To be able to access the MySQL server, the accessing IP address has to be whitelisted. Find your IP address first before proceeding below.
This requires an access to the SQL server.
In MySQL Workbench, open Users and Privileges.
At the bottom left, there's an Add Account button. Click it and use the existing user credentials. Please connect with John Readwin or Stephen Wonfor for the details.
Before saving account, open the Administrative Roles tab and apply the roles below.
Updating the UFW rules
Connect to the Rackspace server via SSH and login to MySQL server locally. Once you are logged in, run the command below.
sudo ufw allow from YOUR_IP to any port 3306
Click to copy
To remove the rule, run the command below.
sudo ufw delete allow from YOUR_IP to any port 3306
Click to copy