For security reasons, you should probably grant select, delete, update and insert to your app user in production.
Have another user who can do alter, create, drop and index when running migrations.
If you run seeders in production, also grant select, insert and references to the migration user.
Yeah, 2 users, migrations are not always run in production everyday and this keeps more secure your database.
| #!/bin/bash | |
| USAGE="\n\x1b[31mUsage:\x1b[0m extract_table_from_mysql_dump.sh my_table /path/to/dump.sql\n\x1b[32mOptional 3rd parameter:\x1b[0m /path/to/export/to\nThe export filename will default to extracted_{my_table}.sql\n" | |
| if [[ -z "$1" ]] ; then | |
| printf "$USAGE" | |
| exit 1 | |
| fi | |
| # Check the table name was provided | |
| if [[ -z "$2" ]] ; then |
| #!/bin/bash | |
| # Globals | |
| TIMESTAMP=$(date +%s) | |
| MOUNT_DIR="/mnt" | |
| BASE_MOUNT_DIR="$MOUNT_DIR/image_$TIMESTAMP" | |
| MOUNT_IMAGE="" | |
| # Usage declaration | |
| display_usage() { |
| <?php | |
| /** | |
| * A quick way, with a bit of overhead, to get nice tabular output | |
| * from a PHP CLI app. | |
| * | |
| * Sometimes I find myself just requiring very quick and dirty | |
| * tabular output and find this to be the path of least resistance. | |
| * | |
| * This method utilises Symfony's Console's Table and BufferedOutput |
| #!/bin/sh | |
| set -e | |
| FIRST_LINE=$(head -n 1 "${1}") | |
| # As the scripts can be either JS or shell, determine how to exec! | |
| if [ "${FIRST_LINE}" = "#!/bin/sh" ] || [ "${FIRST_LINE}" = "#!/bin/bash" ]; then | |
| eval "./$@" | |
| else | |
| # https://github.com/nodejs/docker-node/blob/master/docker-entrypoint.sh |
| <?php | |
| /* | |
| * app/Http/Controllers/Auth/ChangePasswordController.php | |
| * | |
| * Made via the command: | |
| * $ php artisan make:controller Auth/ChangePasswordController -r | |
| * | |
| * This is the custom controller that will do all the heavy lifting for | |
| * changing the users password. |
| Package (in Alphabetical Order) | Description |
|---|
| # Switch Node version in brew | |
| # Place this in your ~/.bashrc or similar for autoload into your shell | |
| function nodesw() { | |
| if [ -z "$1" ]; then | |
| logInfo "You need to provide a Node formulae version to switch to in format:" | |
| logInfo "$ nodesw 16" | |
| if command -v jq >/dev/null 2>&1; then | |
| logInfo "Installed Node versions via Brew:" | |
| brew info --json node | jq -r '.[].versioned_formulae[]' |
| # Switch PHP version in brew | |
| # Place this in your ~/.bashrc or similar for autoload into your shell | |
| function phpsw() { | |
| if [ -z "$1" ]; then | |
| logInfo "You need to provide a PHP formulae version to switch to in format:" | |
| logInfo "$ phpsw 8.1" | |
| if command -v jq >/dev/null 2>&1; then | |
| logInfo "Installed PHP versions via Brew:" | |
| brew info --json php | jq -r '.[].versioned_formulae[]' |
| # List available kubectl contexts | |
| # Based on the below command context storage mechanism | |
| function kswl() { | |
| echo "Listing available kubectl contexts:" | |
| ls -lah ~/.kube/*-config.yaml | |
| } | |
| # Switch kubectl context | |
| # Context files should be stored in the format: ~/.kube/{context_name}-config.yaml | |
| function ksw() { |
