... | ... | @@ -16,6 +16,8 @@ syntax in it looks like this: |
|
|
```
|
|
|
|
|
|
### Database
|
|
|
This Database needs a volume called `blogdb_content`.
|
|
|
create it with: `sudo docker volume create blogdb_content`
|
|
|
the database server needs 3 things:
|
|
|
1. a database called `pyblog`
|
|
|
2. a table called `pyblog_contents` in `pyblog`
|
... | ... | @@ -43,9 +45,13 @@ CREATE IF NOT EXISTS TABLE pyblog_users ( |
|
|
PRIMARY KEY ( uuid )
|
|
|
);
|
|
|
```
|
|
|
now we need to grant permissions to our user:
|
|
|
now we need to add your user:
|
|
|
```sql
|
|
|
GRANT ALL ON pyblog.* to 'uesrname'@'%';
|
|
|
CREATE USER 'username'@'%' IDENTIFIED BY 'password';
|
|
|
```
|
|
|
grant permissions to our user:
|
|
|
```sql
|
|
|
GRANT ALL ON pyblog.* to 'username'@'%';
|
|
|
```
|
|
|
and flush the privileges
|
|
|
```sql
|
... | ... | |