mysql -h 127.0.0.1 -P 3306 -u root -p
CREATE DATABASE developer_service_db;
CREATE USER 'userdev'@'localhost' IDENTIFIED BY 'devpassword';
GRANT ALL PRIVILEGES ON developer_service_db.* TO 'userdev'@'localhost';
ALTER USER 'userdev'@'localhost' IDENTIFIED WITH mysql_native_password BY 'devpassword';
CREATE USER 'userdev'@'%' IDENTIFIED BY 'devpassword';
GRANT ALL PRIVILEGES ON developer_service_db.* TO 'userdev'@'%';
ALTER USER 'userdev'@'%' IDENTIFIED WITH mysql_native_password BY 'devpassword';
FLUSH PRIVILEGES;
Add the next lines at the end of the mysql configuration file. In this case my.cnf
file.
bind-address = 0.0.0.0
wait_timeout = 0
interactive_timeout = 0
Copy my.cnf
file to docker container.
volumes:
- '/data/greenstamp/developer-service/mysql_conf/my.cnf:/etc/my.cnf'
mysql developer_service_db --host=127.0.0.1 --port=3306 -u root -p < dump.sql
Add .env file in the root folder with:
DATABASE_URI=developer_service_db
DATABASE_NAME=developer_service_db
DATABASE_PORT=3307
DATABASE_USER=userdev
DATABASE_PASS=devpassword
APTOIDE_API_BASE_URL=http://ws75.aptoide.com/api/7
pm2 start execpipe.sh
pm2 logs -f execpipe
Restart all analyzers and remote test folders
sudo docker restart $(docker ps -aq)
and run the script to clean all analyzers temporary files:
run clean_server.sh