MySQL via cPanel
Adobe recommends 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.
This article walks you through directly connecting your MySQL database to MBI using cPanel
. This process can also be used to connect Adobe Commerce and any other MySQL-based eCommerce databases to MBI.
cPanel
Get started.
cPanel
Log in to cPanel
via your hosting provider.
Click MySQL Databases, located in the Database
section.
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 you need.
In the User
dropdown of this section, select the user you created.
In the Database
dropdown of this section, select the database you want to connect to MBI.
Click Add.
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, you 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 userPassword
: The password for the MBI MySQL userPort
: MySQL’s port on your server (3306
by default)Host
: The public address of the MySQL
server MBI connects to. This is usually the URL that you use to log into cPanel
.If you are using an SSH tunnel
, you must enter the encryption information. Set the Encrypted
toggle to Yes
to display the form.
Connection Type
: Set this to SSH Tunnel
Remote Address
: The IP address or hostname of the server MBI will tunnel intoUsername
: 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 (22
by default)That is it! When you are finished, click Save & Test to complete the setup.