Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- (venv) donghm@donghm:~/git/pgscm$ sudo docker ps
- CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
- a509a1906fc1 mariadb "docker-entrypoint..." About a minute ago Up About a minute 0.0.0.0:3306->3306/tcp mariadb_pgscm
- (venv) donghm@donghm:~/git/pgscm$ sudo docker exec -it mariadb_pgscm bash
- root@a509a1906fc1:/# mysql -uroot -pdong
- Welcome to the MariaDB monitor. Commands end with ; or \g.
- Your MariaDB connection id is 8
- Server version: 10.2.7-MariaDB-10.2.7+maria~jessie mariadb.org binary distribution
- Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.
- Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
- MariaDB [(none)]> CREATE DATABASE pgscm;
- Query OK, 1 row affected (0.00 sec)
- MariaDB [(none)]> GRANT ALL PRIVILEGES ON pgscm.* TO 'root'@'localhost' \
- -> IDENTIFIED BY 'pgscm';
- Query OK, 0 rows affected (0.00 sec)
- MariaDB [(none)]> GRANT ALL PRIVILEGES ON pgscm.* TO 'root'@'%' \
- -> IDENTIFIED BY 'pgscm';
- Query OK, 0 rows affected (0.00 sec)
- MariaDB [(none)]> exit;
- Bye
- root@a509a1906fc1:/# exit
- exit
- (venv) donghm@donghm:~/git/pgscm$ ls
- adminlte babel.cfg data-dev.sqlite LICENSE MANIFEST.in note.txt __pycache__ README.rst setup.cfg test-requirements.txt tools
- app config.py doc manage.py migrations pgscm quick_start.md requirements.txt setup.py tests tox.ini
- (venv) donghm@donghm:~/git/pgscm$ rm -f data-dev.sqlite
- (venv) donghm@donghm:~/git/pgscm$ python3 manage.py db upgrade
- INFO [alembic.runtime.migration] Context impl MySQLImpl.
- INFO [alembic.runtime.migration] Will assume non-transactional DDL.
- INFO [alembic.runtime.migration] Running upgrade -> 38c4e85512a9, initial migration
- INFO [alembic.runtime.migration] Running upgrade 38c4e85512a9 -> 456a945560f6, login support
- INFO [alembic.runtime.migration] Running upgrade 456a945560f6 -> 56502d362ab5, trackable user info
- INFO [alembic.runtime.migration] Running upgrade 56502d362ab5 -> b91f6260d520, empty message
- Revision ID: b91f6260d520
- Revises: 56502d362ab5
- Create Date: 2017-07-16 18:17:32.791453
- (venv) donghm@donghm:~/git/pgscm$
Add Comment
Please, Sign In to add comment