You can setup the database manually or using the automated script.
We recommend to get a database client to operate to your DB easily, see this page.
db_assembler script and the
acore.sh dashboard both use by default the acore db user for the database connection. Running for the first time the assembler command should create the user for you, however, if you're having permissions error or any other issue with that user, please open your MySQL client with the root user and run the following queries:
DROP USER IF EXISTS 'acore'@'localhost'; DROP USER IF EXISTS 'acore'@'127.0.0.1'; CREATE USER 'acore'@'localhost' IDENTIFIED BY 'acore'; CREATE USER 'acore'@'127.0.0.1' IDENTIFIED BY 'acore'; GRANT ALL PRIVILEGES ON * . * TO 'acore'@'localhost' WITH GRANT OPTION; GRANT ALL PRIVILEGES ON * . * TO 'acore'@'127.0.0.1' WITH GRANT OPTION; FLUSH PRIVILEGES; exit;
It will setup the acore user properly to be used by the db_assembler script
If you don't want to use the default acore user, then you can change the configuration of the script with the following steps:
conf/config.shwith any text editor
DB EXPORTER/IMPORTER CONFIGURATIONS
MYSQL_PASSvariables putting your mysql server settings.
Note: if you're using MySQL 5.7, first run
mysql -e "SET GLOBAL sql_mode = '';" -u root -p first (replace
root with your mysql user).
Note: if you're using Windows you must set-up MySQL as an Environment Variable using this tutorial and run the commands using git bash
import-all: Assemble & Import all
Alternatively, you could also set up your DB manually but this process is harder and not recommended for beginners.