Skip to content

Latest commit

 

History

History
63 lines (54 loc) · 1.43 KB

README.md

File metadata and controls

63 lines (54 loc) · 1.43 KB
Raw

server

Back-End manajemen server

Setup Database

Karena sudah ditambahkan dependency spring boot docker compose dan scopenya runtime. jadi setupnya ada di file docker compose (compose.yaml). oh iya jangan lupa di skip test pas jalanin lewat terminal, kalau lewat idea langsung run aja

mvn clean install spring-boot:run -DskipTests

Tanpa Docker Compose

  • Run MySQL di docker

    docker run --rm \
--name=server-db \
-e MYSQL_DATABASE=serverdb \
-e MYSQL_USER=servermanager \
-e MYSQL_PASSWORD=PNSJkxXvVNDAhePMuExTBuRR \
-e MYSQL_ROOT_PASSWORD=PNSJkxXvVNDAhePMuExTBuRR \
-e TZ=Asia/Jakarta \
-p 6603:3306 \
-v "$PWD/docker/server-db/conf.d":/etc/mysql/conf.d \
-v "$PWD/storage/docker/serverdb-data":/var/lib/mysql \
mysql:8.4

  • Login MySQL

    mysql -uroot -p -h127.0.0.1 -P6603

  • Creat user

    CREATE USER 'servermanager'@'%' IDENTIFIED WITH mysql_native_password BY 'PNSJkxXvVNDAhePMuExTBuRR';

  • Allow access database

    GRANT ALL ON serverdb.* TO 'servermanager'@'%';

    exit;

  • Try login again with new user

    mysql -uservermanager -p -h127.0.0.1 -P6603

  • Show database

    SHOW DATABASES;

    the output:

    +--------------------+
| Database           |
+--------------------+
| information_schema |
| invoicedb          |
+--------------------+
2 rows in set (0,00 sec)