Connect MySQL via cPanel
Jump to
This topic walks you through directly connecting your MySQL database to Commerce Intelligence using cPanel. This process can also be used to connect Adobe Commerce and any other MySQL-based eCommerce databases to Commerce Intelligence.
- Create an Commerce Intelligence MySQL user in cPanel
- Enter connection and user info into Commerce Intelligence
Get started.
Creating an Commerce Intelligence MySQL user in 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 Commerce Intelligence: -
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 forAdd 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 Commerce Intelligence. -
Click Add.
-
When the checklist of privileges appears, check the box next to
SELECT
- this is all Commerce Intelligence needs to connect to your database.
Entering the connection and user info into Commerce Intelligence
To wrap things up, you need to enter the connection and user info into Commerce Intelligence. 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 Commerce Intelligence MySQL userPassword
: The password for the Commerce Intelligence MySQL userPort
: MySQL’s port on your server (3306
by default)Host
: The public address of theMySQL
server Commerce Intelligence connects to. This is usually the URL that you use to log intocPanel
.
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 toSSH Tunnel
Remote Address
: The IP address or hostname of the server Commerce Intelligence will tunnel intoUsername
: The username for the Commerce IntelligenceSSH (Linux)
user, see instructions on how to do this, if you have not already)SSH Port
: SSH port on your server (22
by default)
When you are finished, click Save & Test to complete the setup.