Hello Guys,
How do i get the name of the Database in MySql in Ubuntu?
i need the name of the Database.
Any help please?
1 Like
In the sites directory, within the site configuration file called site_config.json.
1 Like
{
“db_name”: “1bd3e0294da19198”,
“db_password”: “J7LmCEjrQxqDyscp”,
“limits”: {
“space_usage”: {
“backup_size”: 1.0,
“database_size”: 17.95,
“files_size”: 2.0,
“total”: 20.95
}
}
}
Thats what i have there
Thats the name of the database of that site.
This works good.
I have successfully connected my Metabase with ERP NExt
Hi @kolotayo can you give step by step guide of how you connected Metabase with ERP? I was reading Metabase FAQ today. Maybe with your guide I can do it quicker.
Dear @muzzy ;
-
i downloaded metabase from Get started with Metabase and chose my option, copied it to a directory on my PC.
-
i installed Java by following the guide here https://www.digitalocean.com/community/tutorials/how-to-install-java-on-ubuntu-with-apt-get
-
i then used “java -jar metabase.jar” to run my metabase without quotes
-
After installation i then setup my metabase with the step https://www.metabase.com/docs/v0.27.2/setting-up-metabase.html
When i got to Connecting to DB;
- i selected MySQL as ERPNEXT runs a MySQL DB
Name: Name_of_my_Database (it can be any name)
Host: localhost
Port: 3306
Database name: In the sites directory, within the site configuration file called site_config.json you will see db_name there
Database Username: root (default), unless you changed it.
Database Password: This is your MySQL password at the course of installation
Then Allow Metabase to anonymously collect usage events
Click on Next and you are good to go
If you have any issue kindly let me know.
1 Like
Deae @kolotayo. thanks for the information. will try this on my demo instant.
thank for this guide it work fine with me
thanks a lot