Hi, we tried to setup Metabase in our Google cloud where our ERPNext instance is running(https://erp.example.com). I will list out the procedure we followed.
1.First we installed Docker by this guide Docker installation
2.Installed Metabase by this Metabase Docker Guide
3. Commented out the line bind-address = 127.0.0.1 in /etc/mysql/my.cnf .
4. Opened ports 3000 and 3306.
5. Added mysql queries
CREATE USER ‘user_remote_R_only’@‘localhost’ IDENTIFIED BY ‘myStrongeSTpassword’;
CREATE USER ‘user_remote_R_only’@’%’ IDENTIFIED BY ‘myStrongeSTpassword’;
GRANT SELECT ON . TO ‘user_remote_R_only’@‘localhost’;
GRANT SELECT ON . TO ‘user_remote_R_only’@’%’;
flush privileges;
But when i access https://erp.example.com:3000 , nothing is loading, don’t know where went wrong.