bonelifer

CREATE DATABAESE MYNEWDB;

CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';

GRANT ALL PRIVILEGES ON MYNEWDB.* TO 'newuser'@'localhost';

FLUSH PRIVILEGES;

bonelifer

My Linux Cheat Sheets

Create a Backup of the home partition

sudo xfsdump -l 0 -L "Backup level 0 of /home `date`" -M Full  - /home | lzop > /media/oli/Seagate_4TB/Backup/vostro/xfsdump/home-xfsdump-`date +%Y-%m-%d`.lzo

ISO date in bash

DATE=`date +%Y-%m-%d`

check open ports

netstat -tulpn

bonelifer

# rsync-homedir-excludes
#
# A list of files to exclude when backing up *nix home directories using rsync.
#
# Author: Ruben Barkow-Kuder <https://github.com/rubo77/rsync-homedir-excludes>
# Version: 2019-11-30
#
# #Usage:
#    USER=<homedir username here>
#    rsync -aP --exclude-from=rsync-homedir-excludes.txt /home/$USER/ /media/$USER/linuxbackup/home/$USER/

bonelifer

# Can be use to send an url (e.g: http://.../movie.mp4) to your Kodi media center
# You have to enable HTTP control (without password)
# This can be used on an Android Phone with pyDroid (don't forget to pip install requests)
import requests

# Kodi IP address
kodi = "192.168.1.34"

url = input("Enter URL: ")

bonelifer

#!/usr/bin/env python

"""
A simple script to clean kodi's MyVideos sqlite db from obsolete junk.

It will remove all references to non-existing video files and paths.
Records referencing plugins (i.e. YouTube) are ignored.

Bookmarks, settings and streamdetails tables are touched as well, just in case.

bonelifer

#!/bin/bash

# Path to the text file with artist names (one per line)
artist_list_file="./artist_list.txt"

# Where Lidarr should create new artist folders
# This must match a configured Root Folder in Lidarr
lidarr_root="/music/"

# Lidarr API details

bonelifer

#!/bin/bash

# Folder where existing artist folders are located (source)
source_dir="/mnt/media/music/old"

# The Lidarr root folder path to add new artists under
# This must match a configured Root Folder in Lidarr settings
lidarr_root="/music/new"

# Lidarr API access

bonelifer

sudo apt -y update
sudo apt -y install ca-certificates gnupg
sudo install -m 0755 -d /etc/apt/keyrings
curl -fsSL https://download.docker.com/linux/ubuntu/gpg | sudo gpg --dearmor -o /etc/apt/keyrings/docker.gpg
sudo chmod a+r /etc/apt/keyrings/docker.gpg

echo \
    "deb [arch="$(dpkg --print-architecture)" signed-by=/etc/apt/keyrings/docker.gpg] https://download.docker.com/linux/ubuntu \
    "$(. /etc/os-release && echo "$VERSION_CODENAME")" stable" | \
    sudo tee /etc/apt/sources.list.d/docker.list > /dev/null

bonelifer

#!/bin/bash
set -e

###############################################################################################
# This is a convenience script for installing the Github gh CLI. Invoke as follows:           #
# curl -fsSL https://gist.github.com/yourusername/gist-hash/raw/install-gh-cli.sh | sudo bash #
# Author: Mike Stankavich https://github.com/mikestankavich    mike@stankavich.com            #
###############################################################################################

# Root check

bonelifer

#!/bin/bash

set -euo pipefail

RED='\033[0;31m'
GREEN='\033[0;32m'
YELLOW='\033[1;33m'
BLUE='\033[0;34m'
BOLD='\033[1m'
NC='\033[0m'