Database access to another system (from localhost)

ERPNext
1

I want to access my database to another system (from localhost). After searching and following steps from

I am getting this error " ERROR 1290 (HY000): The MariaDB server is running with the --skip-grant-tables option so it cannot execute this statement ".

Googled it and tried that way also that was uncomment the bind-address line but that also didn’t worked.
Also i searched to remotely access mariadb and followed this- How to Allow Remote Access to MariaDB in Ubuntu Linux - Geek Rewind
here file name was erpnext.cnf and there wasn’t those lines mentioned there.

Any help

2

You can download something like HeidiSQL, or mysql-bench (both have freeware/opensource community editions for linux/windows/mac). They allow you to connect to the database via an SSH tunnel and you can then run queries, or use the GUI to examine the DB

1 Like
3

I have used DBeaver , please have a look here
TIP

4

thanks :slight_smile:

1 Like