csdy

-- Create a new database
CREATE DATABASE database_name;

-- Create a new user
CREATE USER 'username'@'%' IDENTIFIED BY 'password';

-- Allow user connections to server
GRANT USAGE ON *.* TO 'username'@'%';

-- Grant user privileges on database

csdy

[Reflection.Assembly]::LoadWithPartialName("System.Drawing")

function CaptureScreenshot([Drawing.Rectangle]$Bounds, $Path) {
    # Initialize image
    $Image    = New-Object Drawing.Bitmap $Bounds.Width, $Bounds.Height
    $Graphics = [Drawing.Graphics]::FromImage($Image)
    $Graphics.CopyFromScreen($Bounds.Location, [Drawing.Point]::Empty, $Bounds.Size)

    # Save screenshot
    $Image.Save($Path)

csdy

Via Browser:
https://ifconfig.me/ip

Via cURL:
curl http://ifconfig.me/ip

Via PowerShell:
(Invoke-WebRequest -uri "http://ifconfig.me/ip").Content

csdy

# Disable Firewall
Set-NetFirewallProfile -Profile Domain, Public, Private -Enabled False

# Enable Firewall
Set-NetFirewallProfile -Profile Domain, Public, Private -Enabled True

csdy

Common Log Locations

Windows

Windows OS

Event Logs
Event logs capture a wide range of system and application events, including errors, warnings, information messages, and security-related events.
Location: %SystemRoot%\System32\winevt\Logs\

csdy

Recycle the Application Pool

Windows Control Panel

• Login to the Windows Control Panel
• Navigate to Website Settings > IIS Settings > Advanced
• Click the "Recycle" button

IIS Manager (Manual)

• Establish a remote desktop connection to the server
• Launch the IIS Manager application

csdy

Enabling Error Display

Server-Wide Error Display (VPS Only)

Windows (VPS Only)

Enable Error Display

• Establish a remote desktop connection to the server
• Open Explorer
• Navigate to C:\PHP\X.X (where "X.X" is the PHP version you wish to modify)

csdy

Enabling Error Display

Windows Control Panel

Enabling Error Display

• Login to the Windows Control Panel
• Navigate to Website Settings > IIS Settings > Advanced
• Change the Error Mode to "Detailed"
• Click the "Save" button

csdy

Enabling Robust Exceptions

Server-Wide Exceptions (VPS Only)

Enabling Exceptions

• Login to the Windows Control Panel
• Navigate to Website Settings > IIS Settings > Advanced
• Change the Error Mode to "Detailed"
• Click the "Save" button
• Login to the ColdFusion Administrator

csdy

Shortcut Keys

Copy/Paste

Copy

CTRL+C

Paste