Access database in ERP Next

Uyya_Vaijeyanthi_Bal · February 10, 2015, 3:58am

How to get connect with ERP Database.

I want to check what are all the tables created.

shraddha · February 10, 2015, 5:25am

Hi,
Steps:-

Go to Terminal
Enter project folder path
Enter command (enter your username and database name) .Both are same.
mysql -u (username) -p (db_name)
4)Press “Enter” button
Enter your db_password
After this , you can access your database

OR
when you create any new ‘doc type’ then table also get created with same name.

Shraddha Ranjane
New Indictrans Technology PVT LTD.

sinaisix · February 10, 2015, 10:39pm

Frankly I think it’d be better for you to stay away from the database if you’ve no idea how to connect to it in the first place. A simple drop used wrongly could cause a lot of anguish

pdvyas · February 11, 2015, 6:31am

You can bench frappe --mysql but it’s recommended that you avoid accessing it directly.