Tony Benavides caffeinetiger

## rename-iam-username.sh
aws iam update-user --user-name <Oldname> --new-user-name <Newname>

## rename-iam-group-name.sh
aws iam update-group --group-name <Oldname> --new-group-name <Newname>

## set_default_version_nvm.sh
nvm alias default <version>

## kubectl_command_using_label_flag.sh
# Example retrieving pod information for pods that have a label 'app' with the value 'my-app'
kubectl get pods -l app=my-app
# Example deleting pods that have a label 'app' with the value 'my-app'
kubectl delete pods -l app=my-app

## create_user.sql
CREATE USER 'master_user'@'%' IDENTIFIED BY 'password';
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, PROCESS, REFERENCES, INDEX, ALTER, SHOW DATABASES, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT, TRIGGER ON *.* TO 'master_user'@'%' WITH GRANT OPTION;

## create_and_update_user_mysql.sql
-- Create User
CREATE USER 'username'@'%' IDENTIFIED BY 'somepassword';
-- Update User
ALTER USER 'username'@'%' IDENTIFIED BY 'somepassword';
-- Grant to Specific Schema/DB
GRANT ALL ON some-schema.* TO 'username'@'%';
-- Grant user permissions similiar to master user in RDS
GRANT ALL PRIVILEGES ON `%`.* TO 'username'@'%' WITH GRANT OPTION;
GRANT LOAD FROM S3 ON *.* TO 'username'@'%';
GRANT SELECT INTO S3 ON *.* TO 'username'@'%';

## grant_s3_to_user_rds.sql
-- Grant statements
GRANT LOAD FROM S3 ON *.* TO 'username'@'%';
GRANT SELECT INTO S3 ON *.* TO 'username'@'%';

-- Replace with appropriate Schema, Table, AWS Region Code, and S3 URI
SELECT * FROM some-schema.some-table INTO OUTFILE S3 's3-some-region-code://some-buck-name/some-prefix'     FIELDS TERMINATED BY ','     LINES TERMINATED BY '\n'

## main.tf
data "aws_region" "current" {}

data "aws_caller_identity" "current" {}

locals {
    aws_region = data.aws_region.current.name
    aws_account_id = data.aws_caller_identity.current.account_id
}

## flush_dns_cache.sh
sudo dscacheutil -flushcache; sudo killall -HUP mDNSResponder

## check_os_version.sh
cat /etc/os-release
	# Example retrieving pod information for pods that have a label 'app' with the value 'my-app'
	kubectl get pods -l app=my-app
	# Example deleting pods that have a label 'app' with the value 'my-app'
	kubectl delete pods -l app=my-app
	CREATE USER 'master_user'@'%' IDENTIFIED BY 'password';
	GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, PROCESS, REFERENCES, INDEX, ALTER, SHOW DATABASES, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT, TRIGGER ON . TO 'master_user'@'%' WITH GRANT OPTION;
	-- Create User
	CREATE USER 'username'@'%' IDENTIFIED BY 'somepassword';
	-- Update User
	ALTER USER 'username'@'%' IDENTIFIED BY 'somepassword';
	-- Grant to Specific Schema/DB
	GRANT ALL ON some-schema.* TO 'username'@'%';
	-- Grant user permissions similiar to master user in RDS
	GRANT ALL PRIVILEGES ON `%`.* TO 'username'@'%' WITH GRANT OPTION;
	GRANT LOAD FROM S3 ON . TO 'username'@'%';
	GRANT SELECT INTO S3 ON . TO 'username'@'%';
	-- Grant statements
	GRANT LOAD FROM S3 ON . TO 'username'@'%';
	GRANT SELECT INTO S3 ON . TO 'username'@'%';

	-- Replace with appropriate Schema, Table, AWS Region Code, and S3 URI
	SELECT * FROM some-schema.some-table INTO OUTFILE S3 's3-some-region-code://some-buck-name/some-prefix' FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n'
	data "aws_region" "current" {}

	data "aws_caller_identity" "current" {}

	locals {
	aws_region = data.aws_region.current.name
	aws_account_id = data.aws_caller_identity.current.account_id
	}