Kaukov

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

Ubuntu	Gentoo	Fedora
bc	sys-devel/bc	bc
bison	sys-devel/bison	bison
build-essential: g++ gcc libc6-dev make	sys-libs/glibc sys-libs/libcxx virtual/libc sys-devel/make	gcc gcc-c++ glibc glibc-devel libcxx libcxx-devel make
ccache	dev-util/ccache	ccache
curl	net-misc/curl	curl
flex	sys-devel/flex	flex
g++-multilib	sys-devel/gcc[multilib,cxx]	gcc-c++.i686
gcc-multilib	-	gcc.i686

My Vim-related gists

Long-form

How to run Melodics on Linux using Bottles

TL;DR: Melodics runs out-of-the-box with the current version of Bottles and its default settings. However Melodics uses your browser to handle logins, and expects your browser to be able to call the Melodics app once logged-in. Read "Melodics Desktop Integration" below to set that up.

Versions tested:

How to run melodics on Linux using Wine

Don't know what Melodics is? Watch this great introduction by Slynk
Download Melodics
I had audio glitches so I had to run the application like this:

export PULSE_LATENCY_MSEC=5\
    && export WINEPREFIX="/home/alinz/.wine"\
    && wine "$USER/.wine/dosdevices/c:/Program Files/Melodics/Melodics.exe"

	[ 0.508870] pci 0000:00:1c.7: [8086:9d17] type 01 class 0x060400
	[ 0.508953] pci 0000:00:1c.7: PME# supported from D0 D3hot D3cold
	[ 0.516546] pci 0000:00:1c.7: PCI bridge to [bus 02]
	[ 0.516551] pci 0000:00:1c.7: bridge window [mem 0xdfa00000-0xdfafffff]
	[ 0.567070] pci 0000:00:1c.7: PCI bridge to [bus 02]
	[ 0.567075] pci 0000:00:1c.7: bridge window [mem 0xdfa00000-0xdfafffff]
	[ 0.658132] aer 0000:00:1c.7:pcie002: service driver aer loaded
	[ 0.658160] pcieport 0000:00:1c.7: Signaling PME through PCIe PME interrupt
	[ 0.658164] pcie_pme 0000:00:1c.7:pcie001: service driver pcie_pme loaded
	[ 2.751878] pcieport 0000:00:1c.7: AER: Corrected error received: id=00e7

	Fetching origin
	checking for a BSD-compatible install... /usr/bin/install -c
	checking whether build environment is sane... yes
	checking for a thread-safe mkdir -p... /usr/bin/mkdir -p
	checking for gawk... gawk
	checking whether make sets $(MAKE)... yes
	checking whether make supports nested variables... yes
	checking whether make supports nested variables... (cached) yes
	checking for gcc... gcc
	checking whether the C compiler works... yes

	Alias Command
	===============================
	g git
	ga git add
	gaa git add --all
	gapa git add --patch
	gau git add --update
	gb git branch
	gba git branch -a
	gbda git branch --merged \| command grep -vE "^(*\|\smaster\s$)" \| command xargs -n 1 git branch -d

	wget https://archive.org/download/archlinux_pkg_mysql-workbench/mysql-workbench-6.3.10-7-x86_64.pkg.tar.xz
	wget https://archive.org/download/archlinux_pkg_mysql-workbench/mysql-workbench-6.3.10-7-x86_64.pkg.tar.xz.sig

	sudo pacman -U mysql-workbench-6.3.10-7-x86_64.pkg.tar.xz

	sudo pacman -S {lib32-,}icu

	sudo ln -s /usr/lib/libicui18n.so /usr/lib/libicui18n.so.61
	sudo ln -s /usr/lib/libicuuc.so /usr/lib/libicuuc.so.61
	sudo ln -s /usr/lib/libicudata.so /usr/lib/libicudata.so.61

	################################################################################
	########### 2024 July 03 - TLP P14s Gen 5 AMD by Sylvain POULAIN ###############
	################################################################################
	# Content of /etc/tlp.d/tlp.conf for P14s Gen 5 AMD
	# (Also works with T14 Gen 5 : same hardware, same motherboard)
	################################################################################
	# Complete harware list => https://linux-hardware.org/?probe=1c547a828f
	################################################################################
	# /!\ For better performance use "acpi.ec_no_wakeup=1" in Kernel option
	# https://patchwork.kernel.org/project/linux-acpi/patch/ZnFYpWHJ5Ml724Nv@ohnotp/