Cygwin bash update console screen dimensions after maximize

$ shopt -s checkwinsize
$ ls
$ shopt -u checkwinsize

source: http://unix.stackexchange.com/questions/61584/how-to-solve-the-issue-that-a-terminal-screen-is-messed-up-usually-after-a-res

Linux Users and Groups Management

Create new User

# adduser [userName]

Note: adduser is a Perl script the helps you tu create the user itselfs and setup their personal informations.

Delete User

# userdel [-r] [userName]

Note: If -r arg was passed, userdel will remove the [userName] home directory

Add existing user to a existing group:

# usermod -a -G [group1[,group2...]] [user]

Remove user from a group

# gpasswd -d [user] [group]

Cygwin Setup command line arguments

 -D --download                     Download from internet
 -L --local-install                Install from local directory
 -s --site                         Download site
 -O --only-site                    Ignore all sites except for -s
 -R --root                         Root installation directory
 -x --remove-packages              Specify packages to uninstall
 -c --remove-categories            Specify categories to uninstall
 -P --packages                     Specify packages to install
 -C --categories                   Specify entire categories to install
 -p --proxy                        HTTP/FTP proxy (host:port)
 -a --arch                         architecture to install (x86_64 or x86)
 -q --quiet-mode                   Unattended setup mode
 -M --package-manager              Semi-attended chooser-only mode
 -B --no-admin                     Do not check for and enforce running as
                                   Administrator
 -h --help                         print help
 -l --local-package-dir            Local package directory
 -r --no-replaceonreboot           Disable replacing in-use files on next
                                   reboot.
 -X --no-verify                    Don't verify setup.ini signatures
 -n --no-shortcuts                 Disable creation of desktop and start menu
                                   shortcuts
 -N --no-startmenu                 Disable creation of start menu shortcut
 -d --no-desktop                   Disable creation of desktop shortcut
 -K --pubkey                       URL of extra public key file (gpg format)
 -S --sexpr-pubkey                 Extra public key in s-expr format
 -u --untrusted-keys               Use untrusted keys from last-extrakeys
 -U --keep-untrusted-keys          Use untrusted keys and retain all
 -g --upgrade-also                 also upgrade installed packages
 -o --delete-orphans               remove orphaned packages
 -A --disable-buggy-antivirus      Disable known or suspected buggy anti virus
                                   software packages during execution.

You can, for example, install packages from DOS command line:

setup-x86.exe -q -P packagename1,packagename2....

source:

• https://cygwin.com/faq-nochunks.html#faq.setup.cli
• http://stackoverflow.com/questions/9260014/how-do-i-install-cygwin-components-from-the-command-line

SQL query to list Users in MySQL Database

>SELECT CONCAT(QUOTE(user),'@',QUOTE(host)) UserAccount FROM mysql.user ORDER BY user ASC;

Setting up Apache Virtual Hosts on XAMPP

C:\xampp\apache\conf\extra\httpd-vhosts.conf

# NameVirtualHost *:80 # deprecated
# NameVirtualHost *:443 # deprecated

<VirtualHost *:80>
        DocumentRoot "C:/XAMPP/htdocs"
        ServerName localhost
    </VirtualHost>
    <VirtualHost *:443>
        DocumentRoot "C:/XAMPP\htdocs"
        ServerName localhost
        SSLEngine on
        SSLCertificateFile "conf/ssl.crt/server.crt"
        SSLCertificateKeyFile "conf/ssl.key/server.key"
    </VirtualHost>

    <VirtualHost *:80>
        DocumentRoot "C:/xampp/htdocs/someSite"
        ServerName [dns]
        ServerAlias [fqdns]
        <Directory "C:/xampp/htdocs/someSite">
            Options Indexes FollowSymLinks Includes ExecCGI
            AllowOverride All
            Order allow,deny
            Allow from all
        </Directory>
    </VirtualHost>
    <VirtualHost *:443>
        DocumentRoot "C:/xampp/htdocs/someSite"
        ServerName [dns]
        ServerAlias [fqdns]
        SSLEngine on
        SSLCertificateFile "conf/ssl.crt/server.crt"
        SSLCertificateKeyFile "conf/ssl.key/server.key"
        <Directory "C:/xampp/htdocs/someSite">
            AllowOverride All
            Order allow,deny
            Allow from all
        </Directory>
</VirtualHost>

Create ImDisk image from command line tool

>rawcopy -mld \\.\Y: "C:\RAM disks\Y.img"

Source: http://forums.guru3d.com/showthread.php?t=356046

XAMPP set root password

$mysqladmin.exe -u root password secret

Source: https://www.apachefriends.org/faq_windows.html