Abhijith Vijayan abhijithvijayan

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

Docker Commands, Help & Tips

Show commands & management commands

$ docker

Docker version info

Each of these commands will run an ad hoc http static server in your current (or specified) directory, available at http://localhost:8000. Use this power wisely.

Discussion on reddit.

Python 2.x

$ python -m SimpleHTTPServer 8000

Keybase proof

I hereby claim:

I am abhijithvijayan on github.
I am abhijithvijayan (https://keybase.io/abhijithvijayan) on keybase.
I have a public key ASA25-4f1U2Ya4TYNUcz-pG9MNki8PPER9BoLnzx-1vNFwo

To claim this, I am signing this object:

Use the following steps to reset a MySQL root password by using the command line interface.

Stop the MySQL service

(Ubuntu and Debian) Run the following command"

sudo /etc/init.d/mysql stop

(CentOS, Fedora, and Red Hat Enterprise Linux) Run the following command:

1. Rename your local branch.

If you are on the branch you want to rename:

git branch -m new-name

If you are on a different branch:

git branch -m old-name new-name

1. Clone your fork:

git clone [email protected]:YOUR-USERNAME/YOUR-FORKED-REPO.git

2. Add remote from original repository in your forked repository:

cd into/cloned/fork-repo
git remote add upstream https://github.com/ORIGINAL-DEV-USERNAME/REPO-YOU-FORKED-FROM.git
git fetch upstream

	const request = require('request');
	const cheerio = require('cheerio');
	const fs = require('fs');
	const writeStream = fs.createWriteStream('post.csv');

	// Write Headers
	writeStream.write(`Title,Link,Date \n`);

	request('http://codedemos.com/sampleblog', (error, response, html) => {
	if (!error && response.statusCode == 200) {

	/* bling.js */

	const $ = document.querySelector.bind(document);
	const $$ = document.querySelectorAll.bind(document);

	Node.prototype.on = window.on = function (name, fn) {
	this.addEventListener(name, fn);
	}

	NodeList.prototype.__proto__ = Array.prototype;

	/* Device = Most of the Smartphones Mobiles (Portrait) */
	$screen-xxs-min: 320px;
	$screen-xxs-max: 480px;

	/* Device = Low Resolution Tablets, Mobiles (Landscape) */
	$screen-xs-min: 481px;
	$screen-xs-max: 767px;

	/* Device = Tablets, Ipads (portrait) */
	$screen-sm-min: 768px;