Want to access mySQL of erpnext

Frappe Framework App Development
1

Hello guys,
I want to access mySQL of erpnext please help me how can i access to that?

2

you can access by using bench mysql

bench --site [sitename] mysql
3

Please provide details i am new here.

5

Just like this phpmyadmin i want to look erpnext’s database table.
640px-phpmyadmin_dbtop

6

@shahid

Use an application like Sequel Pro or if you are on a PC you can use DB Visualizer or somethning similiar on PC.

Alternately, you can view using the terminal by logging into bench mysql

Hope this helps

2 Likes
7

try
bench --site site_name mariadb

1 Like
8

Even you can use phpmyadmin since ERPNext too uses mysql

9

You can use workbench

1 Like
10

Hi there - I have the virtualbox image. I’ve been trying for hours to connect via mysql workbench. Do I need to edit some config files? I noticed I could not use localhost:8000 but it works when I use 127.0.0.1:8000.

I just want to be able to edit mysql tables but I am struggling to get connected from mysql workbench as it says access denied after initially connecting.

I appreciate the help.

11

in your hosts file, add
127.0.0.1 localhost

the settings for the workbench would depend on the IP address of the workstation on the LAN. use a connect via SSH tunnel.
If it’s LAN address is say 192.168.1.100, then the workbench setings would be like this…
SSH setting: 192.168.1.100 (user=frappe, password=frappe). port is either 22, or 3022
mysql settings: 127.0.0.1 (user=root, password=frappe). port is normally 3306