Skip to content

Instantly share code, notes, and snippets.

Avatar
🏰
Preparing for big things...

Mulia Nasution mul14

🏰
Preparing for big things...
View GitHub Profile
@mul14
mul14 / mysql_create_new_user.sql
Created May 15, 2022
MySQL: Create new user with native password
View mysql_create_new_user.sql
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
mul14 / docker-compose.yml
Last active Jun 4, 2022
Docker compose for PHP 7.2, MySQL 5.7, Adminer
View docker-compose.yml
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
mul14 / switch_to_mysql_native_password.md
Created Jan 18, 2022 — forked from rohsyl/switch_to_mysql_native_password.md
MariaDB switch to mysql_native_password
View switch_to_mysql_native_password.md

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
mul14 / README.md
Created Mar 24, 2021 — forked from danbst/README.md
[Linux] [Firefox] Open link in browser, which is in current workspace
View README.md

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
mul14 / 99-install-facetime-camera.sh
Created Nov 21, 2020 — forked from ukn/99-install-facetime-camera.sh
Install the kernal module required for the facetimehd camera to work on Linux
View 99-install-facetime-camera.sh
#!/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
mul14 / create_new_user.sql
Last active Nov 16, 2020
MySQL/MariaDB mysql_native_password
View create_new_user.sql
CREATE USER 'mul14'@'localhost' IDENTIFIED BY 'secret_password';
GRANT ALL PRIVILEGES ON *.* TO 'mul14'@'localhost' WITH GRANT OPTION;
FLUSH PRIVILEGES;
@mul14
mul14 / graphql_query.js
Last active Nov 21, 2020
Simple GraphQL Client for web browser
View graphql_query.js
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
mul14 / ApproachingFibonacci.js
Last active Jun 4, 2022
Someone give me some coding test on CoderByte. Here are the questions and my answers.
View ApproachingFibonacci.js
/*
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
mul14 / demo.sh
Last active Jun 4, 2022
I very often create new folder to demonstrate or experiment. Run mkdir, cd, git init, etc; each time when I need is painful. So, I create this simple bash script.
View demo.sh
#!/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
@mul14
mul14 / DefaultKeyBinding.dict
Created Aug 4, 2019 — forked from trusktr/DefaultKeyBinding.dict
My DefaultKeyBinding.dict for Mac OS X
View DefaultKeyBinding.dict
/* ~/Library/KeyBindings/DefaultKeyBinding.Dict
This file remaps the key bindings of a single user on Mac OS X 10.5 to more
closely match default behavior on Windows systems. This makes the Command key
behave like Windows Control key. To use Control instead of Command, either swap
Control and Command in Apple->System Preferences->Keyboard->Modifier Keys...
or replace @ with ^ in this file.
Here is a rough cheatsheet for syntax.
Key Modifiers