Tagged articles
113 articles
Page 2 of 2
MaGe Linux Operations
MaGe Linux Operations
Feb 3, 2018 · Databases

Master MySQL: From Basics to Advanced Operations and Essential Tools

This comprehensive guide introduces MySQL fundamentals, walks through installation on Windows and Linux, explains core commands for connecting, creating databases, managing users and privileges, performing table CRUD operations, handling data types, and provides a curated list of analysis, backup, performance, HA, and GUI tools for MySQL.

CRUDData TypesInstallation
0 likes · 23 min read
Master MySQL: From Basics to Advanced Operations and Essential Tools
MaGe Linux Operations
MaGe Linux Operations
Dec 4, 2017 · Information Security

How to Harden Your Linux Server Against Unauthorized Access

This guide walks you through essential steps to secure a Linux server, including regular system updates, automatic security patches, creating restricted user accounts, hardening SSH with key authentication and daemon options, deploying Fail2Ban, removing unused services, and configuring firewalls for robust protection.

Fail2banSSH HardeningServer Security
0 likes · 13 min read
How to Harden Your Linux Server Against Unauthorized Access
ITPUB
ITPUB
Aug 1, 2017 · Operations

Master Linux User and Group Management: Commands, Files, and Best Practices

This guide explains how Linux stores user and group information in /etc/passwd, /etc/shadow, /etc/group and /etc/gshadow, and provides detailed usage of commands such as useradd, usermod, userdel, groupadd, groupmod, gpasswd, and passwd for creating, modifying, locking, and deleting accounts and groups.

User Managementgroup-managementpasswd
0 likes · 19 min read
Master Linux User and Group Management: Commands, Files, and Best Practices
ITPUB
ITPUB
Jul 19, 2017 · Databases

SQL Server vs Oracle: 10 Essential Syntax and Feature Differences

This guide compares SQL Server and Oracle across ten key areas—including data types, date functions, default constraints, string concatenation, identity columns, conditional statements, CASE syntax, triggers, stored procedures, and user creation—providing concrete code examples for each difference.

Data TypesDatabase SyntaxOracle
0 likes · 8 min read
SQL Server vs Oracle: 10 Essential Syntax and Feature Differences
MaGe Linux Operations
MaGe Linux Operations
Mar 28, 2017 · Information Security

Hardening Linux Servers: Essential Security Configurations & Best Practices

This guide walks through comprehensive Linux server hardening techniques, covering user account management, service minimization, file permission tightening, virtual memory tuning, log handling, and firewall configuration with iptables and ipchains, providing step‑by‑step commands and screenshots to enhance system security and stability.

HardeningServer SecuritySystem optimization
0 likes · 16 min read
Hardening Linux Servers: Essential Security Configurations & Best Practices
ITPUB
ITPUB
Nov 14, 2016 · Databases

How to Create, Manage, and Revoke MySQL Users and Permissions

This guide explains multiple methods for creating MySQL users, deleting them, assigning granular permissions, revoking privileges, and understanding when permission changes take effect, complete with command examples and a comprehensive list of MySQL privilege types.

PermissionsUser Managementmysql
0 likes · 9 min read
How to Create, Manage, and Revoke MySQL Users and Permissions
dbaplus Community
dbaplus Community
Oct 25, 2016 · Databases

Master MySQL: Essential Database Operations, Table Management, and Index Optimization

This guide walks through MySQL fundamentals—including viewing, creating, and using databases, managing users and privileges, creating and altering tables, inserting, updating, deleting, and querying data, as well as index types, best‑practice tips, and execution‑plan analysis—providing concrete commands and examples for each step.

TableUser Managementdatabase
0 likes · 14 min read
Master MySQL: Essential Database Operations, Table Management, and Index Optimization
ITPUB
ITPUB
May 6, 2016 · Backend Development

Why User Management Is Harder Than It Looks: Business, UI, and Validation Code

The article breaks down the hidden complexity of implementing user management by analyzing business requirements, detailing the multiple UI pages needed, estimating development effort, and providing reusable C# validation utilities for strings, emails, URLs, and numeric inputs.

BackendCRUDSoftware Architecture
0 likes · 9 min read
Why User Management Is Harder Than It Looks: Business, UI, and Validation Code
Qunar Tech Salon
Qunar Tech Salon
Mar 26, 2016 · Databases

MySQL User Management, Database and Table Operations Guide

This guide provides step‑by‑step instructions for connecting to MySQL, creating and managing users and permissions, displaying, creating and deleting databases and tables, performing backups and restores, and executing various query operations such as selecting, updating, and aggregating data.

BackupDatabase operationsQueries
0 likes · 14 min read
MySQL User Management, Database and Table Operations Guide