kdiniantoro

MySQL Cheat Sheet

Help with SQL commands to interact with a MySQL database

MySQL Locations

Mac /usr/local/mysql/bin
Windows /Program Files/MySQL/MySQL version/bin
Xampp /xampp/mysql/bin

Add mysql to your PATH

Docker Commands, Help & Tips

Show commands & management commands

$ docker

Docker version info

Wordpress & Docker

This file will setup Wordpress, MySQL & PHPMyAdmin with a single command. Add the code below to a file called "docker-compose.yaml" and run the command

$ docker-compose up -d

# To Tear Down
$ docker-compose down --volumes

SSH Cheat Sheet

This sheet goes along with this SSH YouTube tutorial

Login via SSH with password (LOCAL SERVER)

$ ssh brad@192.168.1.29

Create folder, file, install Apache (Just messing around)

$ mkdir test

$ cd test

VSCode Shortcuts

List of helpful shortcuts for faster coding

Official List of all commands

Windows
Mac

Open/View

Flutter Setup & Notes

1. Download SDK

Download Flutter SDK, extract the "Flutter" folder and put somewhere on your machine https://flutter.dev/docs/get-started/install

2. Add path

Add path for 'location/flutter/bin'

	<?php
	$host = 'localhost';
	$user = 'root';
	$password = '123456';
	$dbname = 'pdoposts';

	// Set DSN
	$dsn = 'mysql:host='. $host .';dbname='. $dbname;

	// Create a PDO instance

	#! /bin/bash

	# ECHO COMMAND
	# echo Hello World!

	# VARIABLES
	# Uppercase by convention
	# Letters, numbers, underscores
	NAME="Bob"
	# echo "My name is $NAME"

	<!DOCTYPE html>
	<html lang="en">
	<head>
	<meta charset="UTF-8">
	<meta name="viewport" content="width=device-width, initial-scale=1.0">
	<meta http-equiv="X-UA-Compatible" content="ie=edge">
	<link rel="stylesheet" href="style.css">
	<title>Devtools Test</title>
	</head>
	<body>

	# -- coding: utf-8 --
	#!/usr/bin/python
	import subprocess
	import os
	import picamera
	import time
	import shlex
	from datetime import datetime
	from datetime import timedelta
	import datetime as dt