| /***** "Remote" server first *****/ | |
| -- Note: Unless the object you are trying to gain access to is in the same DATABASE, it's a remote datebase. Even if it's | |
| -- on the same node! | |
| -- 1. create the role and assign it a password. Note: CREATE USER is an alias for CREATE ROLE. Either one is fine | |
| CREATE ROLE new_user WITH PASSWORD 'somepassword'; | |
| -- 2. Grant the required permissions. This grants select, insert, update, and delete on all tables in the public schema. | |
| -- I also gave execute to all functions in the public schema as well. | |
| GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA public TO new_user; | |
| GRANT EXECUTE ON ALL FUNCTIONS IN SCHEMA public TO new_user; |
If you're trying to load a private repository with Composer/Laravel, we'll need to generate a GitHub Personal Access Token (similar to OAuth token) to access the repository during a composer install without entering credentials.
If you have used other Github packages from
{my-org}before, you may be able to skip this step.
Click Generate new token.
| # Backup | |
| docker exec CONTAINER /usr/bin/mysqldump -u root --password=root DATABASE > backup.sql | |
| # Restore | |
| cat backup.sql | docker exec -i CONTAINER /usr/bin/mysql -u root --password=root DATABASE | |
| # Assume we are in your home directory | |
| cd ~/ | |
| # Clone the repo from GitLab using the `--mirror` option | |
| $ git clone --mirror [email protected]:mario/my-repo.git | |
| # Change into newly created repo directory | |
| $ cd ~/my-repo.git | |
| # Push to GitHub using the `--mirror` option. The `--no-verify` option skips any hooks. |
| grammar org.json.Json with org.eclipse.xtext.common.Terminals | |
| generate json "http://www.json.org/" | |
| Object: | |
| '{' ((members+=Member) (',' members+=Member)*)? '}'; | |
| Member: | |
| key=STRING ':' value=Value; | |