Log in

Look for DATABASES and click MySQL Databases

Create new Schema

In order to create, type the desired name in the blank space and click Create Database.

In this case we will create a new database Schema named: mydvtech_myexample. Noticed how we have to keep the main user name mydvtech to the left of the underscore.

Confirmation window of new Schema.

Notice how the new database schema name is listed as mydvtech_myexample.

Look databases list.

Noticed how it has a blank space for the Privileged User.

Add a new user

For this we can create a new one from the user’s section.

In this example we are creating a new user named: mydvtech_usersmp.

Please make sure to follow the instructions for the password, or just generate a password.

For illustration reasons, we are creating a password: ABC123456

Confirmation window of new user.

Add the user to a database

Select the user’s Privileges

From this window, you can select the privileges associated to the user, once you have selected them click Make Changes.

Confirmation message

Select Go Back.

Finalized database schema

Our finalized database schema with privileged user assignment.

Obtain IP Address

Your end user including your self, need to find your unique IP address by visiting the following site:

http://www.inmotionhosting.com/support/ipcheck.php

Select Remote MySQL

From the cPanel home, select Remote MySQL

Remote MySQL setup

From the new window, add the Remote IP address from your location or team member’s location.

Add Remote MySQL setup

Remote MySQL setup confirmation

Confirmation window.

Remote MySQL setup confirmation

Confirmation window.

Create new MySQL connection

Connection Name: Your desired connection name (In this case mydvtech.com)

Host Name: YourDomain.com (In this case is mydvtech.com)

User Name: YourMySQLUser (In this case is mydvtech_usersmp)

Password: YourMySQLPassword (In this case is ABC123456)

Test connection

If the team member’s IP address, or the user information and/or password has no been successfully added, it will return an unsuccessful connection response!

Close window

Start connection

View of Schema once connected