🔗 Connect Docker Frappe MySQL to Zoho Analytics

This guide explains the step-by-step process to enable remote access to the MySQL (MariaDB) database used in a Dockerized Frappe setup and connect it to Zoho Analytics.

📋 Prerequisites

Frappe running inside Docker
MariaDB as your database
Access to your server terminal
Zoho Analytics account with Database Connection feature

⚙️ Step 1: Enable Remote Access to MariaDB

1.1 Access the Host Machine (not inside Docker)

ssh user@your-server-ip

1.2 Edit the MariaDB Configuration File

Use nano or any text editor:

sudo nano /etc/mysql/my.cnf

Or in some cases (Debian-based systems), use:
sudo nano /etc/mysql/mariadb.conf.d/50-server.cnf

1.3 Update the Bind Address

Look for the line:

bind-address = 127.0.0.1

Replace it with:

bind-address = 0.0.0.0

This allows MySQL to accept connections from any IP.

🔄 Step 2: Restart MariaDB

sudo service mysql restart

or

sudo systemctl restart mariadb

🔑 Step 3: Grant Remote Access to MySQL User

Login to MySQL:

mysql -u root -p

Then run:

GRANT ALL PRIVILEGES ON *.* TO 'your_user'@'%' IDENTIFIED BY 'your_password' WITH GRANT OPTION;
FLUSH PRIVILEGES;

✅ This allows your_user to connect from any IP.

Docker MySQL to Zoho Analytics