Back-office to manage RSS XML feeds from multiple sources.
The following command can be run to create a docker container for MySQL:
docker run --name=MySQL -e MYSQL_ROOT_PASSWORD=<root_password> --publish=3306:3306 --hostname=mysqlserver --restart=on-failure --detach mysql/mysql-server:latest
Open an interactive shell to access the container with:
docker exec -it MySQL /bin/bash
Once in, connect to MySQL with root:
mysql -uroot -p
Then type in the <root_password>
used when creating the docker container.
Finally, create the database and user, and grant privileges as follows:
-- Create database.
CREATE DATABASE newsaggregator character set utf8mb4 collate utf8mb4_bin;
-- Create user.
CREATE USER 'newsaggregator'@'%' IDENTIFIED BY 'ic9d3L!Hq^54';
-- Grant privileges.
GRANT ALL PRIVILEGES ON newsaggregator.* TO 'newsaggregator'@'%';
-- Apply changes.
FLUSH PRIVILEGES;
Just use the gradle wrapper and execute the bootRun task:
./gradlew bootRun