Skip to content

Instantly share code, notes, and snippets.

View abhi11verma's full-sized avatar

Abhishek Verma abhi11verma

View GitHub Profile
@abhi11verma
abhi11verma / server related permission
Last active January 10, 2019 12:44
Ubuntu-configs
@abhi11verma
abhi11verma / Grade
Last active December 20, 2018 07:11
SQL Queries
WITH latest_anthro_encounters AS (
SELECT
i.id AS individual_id,
i.address_id AS address_id,
penrol.id AS enrolment_id,
max(program_encounter.encounter_date_time) AS max_date
FROM
individual i
JOIN program_enrolment penrol ON penrol.program_id = 2 AND i.id = penrol.individual_id
JOIN program_encounter ON penrol.id = program_encounter.program_enrolment_id
@abhi11verma
abhi11verma / Change Mysql password
Last active March 27, 2019 09:39
Database Commands
mysqladmin --user=root --password=oldpassword password "newpassword"
-- For other users
MySQL > SET PASSWORD FOR ‘anthony’@’localhost’ = PASSWORD(‘text password’);
##inistall apache
sudo apt-get install apache2
##install php
sudo apt install php libapache2-mod-php php-mysql
sudo apt install php-cli
sudo apt install php-curl
# Installing Mysql
## Install Docker
@abhi11verma
abhi11verma / Stash
Created December 28, 2018 10:42
Git
git stash save "NAME_YOU_WANT_TO_GIVE_TO_STASH"
git checkout -b xxx
git stash pop [DELETES AFTER APPLYING INSTEAD USE BELOW]
git stash list
git stash apply stash @{stashid from the list}
Step 1: Goto your Android sdk folder -> platform tools and copy the whole path
For example: C:\Program Files (x86)\Android\android-sdk\platform-tools
Step 2: Goto command prompt or Android studio terminal
cd C:\Program Files (x86)\Android\android-sdk\platform-tools
and press enter
https://stackoverflow.com/questions/18363833/how-can-i-list-upnp-server-renderer-in-command-line-console-mode-on-linux
The Simple Service Discovery Protocol (SSDP) is a network protocol based on the Internet Protocol Suite for advertisement and discovery of network services and presence information. It accomplishes this without assistance of server-based configuration mechanisms, such as DHCP or DNS, and without special static configuration of a network host. SSDP is the basis of the discovery protocol of Universal Plug and Play (UPnP) and is intended for use in residential or small office environments.
gssdp-discover -i wlan0 --timeout=3
Remove the config file
rm ~/.config/KeeWeb/runtime-data.json
delete ~/Library/Application\ Support/KeeWeb/runtime-data.json
https://github.com/Varying-Vagrant-Vagrants/VVV/issues/741
@abhi11verma
abhi11verma / Mount smb on ubuntu
Last active January 12, 2019 17:18
Raspberry Pi
sudo mount -t cifs //192.168.31.156/share /media/NFShare/
## Unmount
umount -f /mnt/fileshare
## Fstab change for Host Ubuntu
//192.168.31.156/share /media/NFShare cifs guest,uid=1000,iocharset=utf8 0 0
[https://askubuntu.com/questions/1050460/how-to-mount-smb-share-on-ubuntu-18-04]