By default, MySQL permissions only permit same-server access for clients. This protects your database by preventing external access, but also precludes desktop database utilities like Navicat, MySQL Workbench, and Eclipse from managing your database schema.
Create a new MySQL user within the control panel under Databases > MySQL Manager.
- Enter a user under Name
- Remember: your newly-created user will be prefixed with your database prefix that precedes the input field
- Enter a password under the Password field
- Select Advanced mode
- Enter a new host under the Host field
- Only IP addresses are accepted
- Use _ and % for single/multiple wildcards
- 64.22._0.1 matches 220.127.116.11 and 18.104.22.168 but not 22.214.171.124
- 62.22.% matches 126.96.36.199, 188.8.131.52, etc but not 184.108.40.206
- 64.22.%.1 would match 220.127.116.11, 18.104.22.168, but not 22.214.171.124
- Click Add User
A user has been created, but now requires database privileges:
- Select Change Mode > List Users and Databases
- Select the database under Edit Databases > Database Name.
- Under User Privileges, select READ and WRITE
- READ will permit the user to connect and issue SELECT statements
- WRITE will permit INSERT, UPDATE, and DELETE
- Click Save
Connect to the database using your server name (or domain name), and corresponding username + password previously created. Port is the default port 3306.