Connect MariaDB remotely from Any DB manager

[Sathams_Tech_TV]

Hi Team ,
I am trying to connect MariaDb remotly from navicat .But I couldn’t able to able make connection.FYI My erpnext hosted in aws ec2. Please help me on this.

[System19]

site_config.json located within frappe/frape-bench/sites/yoursitename.whatever lists your DB name.
You can also access MariaDB via mysql commands just as you would any mySQL DB

[Riyas_Rawther]

Please refer this post How I created this Sales KPI Dashboard - #3 by kevingee

[Riyas_Rawther]

Also you need to open the Database ports to where you installed the NaviCat Server. Please don’t open the port to the public. Only to the server public IP.

It is called Security Groups in AWS

[Sagar_Bhogayata]

You can use workbench

Connecting MariaDB on MySQL Workbench

By default MariaDB only allows localhost connection,To allow remote access to MariaDB… sudo nano /etc/mysql/my.cnf comment out bind-address sudo service mysql restart login mariaDB as root user ~$ mysql -uroot -pYourMariaDBrootPassword grant privileges MariaDB [(none)]>GRANT ALL PRIVILEGES ON . TO ‘root’@‘%’ IDENTIFIED BY ‘YourMariaDBrootPassword’ WITH GRANT OPTION; in mysqlbench login as root

[Sathams_Tech_TV]

Thank you for the response…It works for me.
I am using Navicat TCP/IP over SSH and it works.

1.Login with SQL user credential :

1.

2.Enter SSH credential (Ex:Ubuntu…)