karim imkarimkarim

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

MongoDB Cheat Sheet

Show All Databases

show dbs

Show Current Database

Elementary OS config

This is a simple guide for myself about how to replicate my current eOS setup if I ever need to. These are my themes, customazations and tweaks to the OS, categorized and clearly written down for future me if he ever needs it.

Install software

Install updates

Always update when installing an new OS.

Reset all user settings for VSCode (Code OSS) on Linux

(Archlinux in my case)
Reset all settings and extensions. Like a fresh and clean VSCode installation.

Close VSCode
Remove the ~/.vscode-oss folder and the ~/.config/Code - OSS/ folder

~ is a shorthand for your user folder /home/username but should work on all unix systems

Via Console:

WARNING: This will remove all your settings and installed extensions without any prompt

Webpack & Tailwind CSS Setup

Create your package.json

npm init -y

Create your src folder

Create a folder called src and add an empty index.js file. The code that webpack compiles goes in here including any Javascript modules and the main Tailwind file.

Linux Server Setup & MERN App Deployment

These are the steps to setup an Ubuntu server from scratch and deploy a MERN app with the PM2 process manager and Nginx. We are using Linode, but you could just as well use a different cloud provider or your own machine or VM.

Create an account at Linode

Click on Create Linode

Choose your server options (OS, region, etc)

SSH Keys

Common Terminal Commands

Key Commands & Navigation

Before we look at some common commands, I just want to note a few keyboard commands that are very helpful:

Up Arrow: Will show your last command
Down Arrow: Will show your next command
Tab: Will auto-complete your command
Ctrl + L: Will clear the screen

	[
	{
	"province": "اردبیل",
	"cities": [
	"اردبیل",
	"اصلاندوز",
	"آبی بیگلو",
	"بیله سوار",
	"پارس آباد",
	"تازه کند",

	module.exports = {
	/**
	* Print Width
	* https://prettier.io/docs/en/options.html#print-width
	*
	* Specify the line length that the printer will wrap on.
	*
	* printWidth: <int>
	* default: 80
	*/

	deb http://archive.ubuntu.com/ubuntu/ jammy main restricted universe multiverse
	# deb-src http://archive.ubuntu.com/ubuntu/ jammy main restricted universe multiverse

	deb http://archive.ubuntu.com/ubuntu/ jammy-updates main restricted universe multiverse
	# deb-src http://archive.ubuntu.com/ubuntu/ jammy-updates main restricted universe multiverse

	deb http://archive.ubuntu.com/ubuntu/ jammy-security main restricted universe multiverse
	# deb-src http://archive.ubuntu.com/ubuntu/ jammy-security main restricted universe multiverse

	deb http://archive.ubuntu.com/ubuntu/ jammy-backports main restricted universe multiverse