We strongly recommend you use SSH or some other form of encryption to secure your data! If this is not an option, you can still directly connect MBI to your database using the instructions in this article.
In this article, we walk you through directly connecting your MySQL database to MBI using cPanel``. This process can also be used to connect Magento and any other MySQL-based eCommerce databases to MBI.
cPanel via your hosting provider.
Click MySQL Databases, located in the
Scroll down to the
Add New User section and create a user for MBI:
Click Create User.
Now that you have created the user, you need to associate it to a database. Go back to the
Add New User section - see the settings for
Add User to Database? That is what we need.
User dropdown of this section, select the user you created.
Database dropdown of this section, select the database you want to connect to MBI.
When the checklist of privileges appears, check the box next to
SELECT - this is all MBI needs to connect to your database.
To wrap things up, we need to enter the connection and user info into MBI. Did you leave the MySQL credentials page open? If not, go to Manage Data > Connections and click Add New Data Source, then the MySQL icon.
Enter the following info into this page in the
Database Connection section:
Username: The username for the MBI MySQL user
Password: The password for the MBI MySQL user
Port: MySQL’s port on your server (
Host: The public address of the
MySQLserver MBI will connect to. This is usually the URL you use to log into
If you are using an
SSH tunnel, you will also need to enter the encryption information. Set the
Encrypted toggle to
Yes to display the form.
Connection Type: Set this to
Remote Address: The IP address or hostname of the server MBI will tunnel into
Username: The username for the MBI
SSH (Linux)user, see instructions on how to do this, if you have not already)
SSH Port: SSH port on your server (
That is it! When you are finished, click Save & Test to complete the setup.