Skip to content

Instantly share code, notes, and snippets.

View schaternik's full-sized avatar

Anastasia schaternik

44 followers · 26 following
  • Berlin, Germany
  • 08:27 (UTC +02:00)
View GitHub Profile
@schaternik
schaternik / whatis_whereis_which.md
Last active September 2, 2024 13:23
Linux: where vs whereis vs which vs whatis

whatis

  • whatis - display one-line manual page descriptions
  • whatis -w 'ab*' - search using wildcards
  • whatis -r '^ab' - search using regexps

whereis

  • whereis - locate the binary, source, and manual page files for a command
  • whereis -b vagrant - locate binary
  • whereis -m vagrant - locate man pages
  • whereis -s vagrant - locate source
@schaternik
schaternik / mysql.md
Last active February 12, 2018 13:25
Mysql CLI

  • check my sql installation mysql -V

  • login as root mysql -u root -p

  • SELECT User FROM mysql.user; - get list of the all database users

  • CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password'; - create new use with specified password

  • GRANT ALL PRIVILEGES ON * . * TO 'aska'@'localhost'; - grant the all privileges

  • vim /etc/mysql/my.cnf - mysql config file

  • sudo /etc/init.d/mysql restart

@schaternik
schaternik / pg_hba.conf
Last active February 12, 2018 13:22
Postgresql setup
# Database administrative login by Unix domain socket
local all postgres peer
# TYPE DATABASE USER ADDRESS METHOD
# "local" is for Unix domain socket connections only
local all all md5
# IPv4 local connections:
host all all 127.0.0.1/32 md5
# IPv6 local connections:
@schaternik
schaternik / regional-setting.md
Last active August 29, 2015 14:22
Set up Regional Settings with command line in Linux
@schaternik
schaternik / mysql_database.yml.example
Created December 24, 2015 11:10
default: &default
adapter: mysql2
encoding: utf8
pool: 5
username: root
password:
socket: /var/run/mysqld/mysqld.sock
development:
<<: *default
@schaternik
schaternik / postgresql_database.yml.example
Last active September 14, 2016 07:00
default: &default
adapter: postgresql
encoding: unicode
pool: 5
username: alabama_song
password: 1
development:
<<: *default
database: alabama_song_development
@schaternik
schaternik / frozen_string_literals.rb
Created April 30, 2018 19:35 — forked from samanthamjohn/frozen_string_literals.rb
comment = "# frozen_string_literal: true\n"
filemode = "r+"
dirs = Dir[Rails.root.join('spec/**/*.rb').to_s] + Dir[Rails.root.join('lib/**/*.rake').to_s] + Dir[Rails.root.join('lib/**/*.rb').to_s]
dirs.each do |filename|
contents = File.open(filename, "r") do |f|
f.read
end
contents = comment + contents
@schaternik
schaternik / secret-key-base.rb
Last active February 6, 2019 13:48
Generate secreta key base like rails does it in IRB
require 'securerandom'
puts SecureRandom.hex(64)
@schaternik
schaternik / .editorconfig
Created February 28, 2019 23:57
Sample editor config file
# https://editorconfig.org/#example-file
root = true
[*]
indent_style = space
indent_size = 2
end_of_line = lf
charset = utf-8
trim_trailing_whitespace = true
@schaternik
schaternik / tree.go
Created October 18, 2019 12:49
package main
import (
"fmt"
"io"
"os"
"path"
)
func dirTree(out io.Writer, root string, printFiles bool) error {