Hello guys,
I want to access mySQL of erpnext please help me how can i access to that?
you can access by using bench mysql
bench --site [sitename] mysql
Please provide details i am new here.
Just like this phpmyadmin i want to look erpnext’s database table.
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
try
bench --site site_name mariadb
Even you can use phpmyadmin since ERPNext too uses mysql
You can use workbench
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.
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