mul14

Check current MySQL timezone:

SELECT @@global.time_zone, @@session.time_zone;

The value might be SYSTEM, UTC, or your current MySQL timezone.

If you want to change the default MySQL timezone to something else (e.g Asia/Jakarta), run this query:

SET GLOBAL time_zone = 'Asia/Jakarta';

mul14

CREATE USER 'username'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';

ALTER USER 'username'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';

GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost';

FLUSH PRIVILEGES;

-- Reference: https://www.digitalocean.com/community/tutorials/how-to-create-a-new-user-and-grant-permissions-in-mysql

mul14

version: '3.8'

services:
  nginx:
    image: nginx:1.21
    ports:
      - "8000:80"
    volumes:
      - .:/var/www/html
      - ./site.conf:/etc/nginx/conf.d/default.conf

mul14

Switch to mysql_native_password plugin

By default MariaDB use the unix_socket plugin to authenticate users.

But it's easier to use mysql_native_password for dev (and only for dev because it's way less secure).

Get root access

sudo su

mul14

I use separate Firefox profiles for work and personal stuff. To distinguish those I place them on different workspaces.

• Workspace 0: firefox --no-remote -P MyJob
• Workspace 1: firefox --no-remote -P default

I have also company Slack on Workspace 0. Which usually contains links to some work stuff.

The problem

mul14

#!/bin/bash
set -e

export CONFIG_MODULE_SIG=n
export CONFIG_MODULE_SIG_ALL=n
# For current kernel
export KERNELRELEASE=$(cat /proc/version | awk '{print $3}')

temp_dir=$(mktemp -d)
echo "Installing FacetimeHD camera for $KERNELRELEASE"

mul14

CREATE USER 'mul14'@'localhost' IDENTIFIED BY 'secret_password';
GRANT ALL PRIVILEGES ON *.* TO 'mul14'@'localhost' WITH GRANT OPTION;
FLUSH PRIVILEGES;

mul14

function graphql_query(endpoint, query, variables = {}, token = null) {
  return new Promise((resolve, reject) => {
    const headers = {
      'Content-Type': 'application/json',
    }

    if (token) {
      headers['Authorization'] = `Bearer ${token}`
    }

mul14

/*
  Have the function 
  ArithGeo(arr)
  take the array of numbers stored in 
  arr
  and return the string 
  "Arithmetic"
  if the sequence follows an arithmetic pattern or return 
  "Geometric"
  if it follows a geometric pattern. If the sequence doesn't follow either pattern return 

mul14

#!/bin/bash

demo () {
  project_name=""

  if [ $# -eq 0 ]; then
    project_name=$(cat /dev/urandom | tr -dc 'a-zA-Z0-9' | fold -w 6 | head -n 1)
  else
    if [[ ( $1 == "--help") || $1 == "-h" ]]; then
      cat << EOF