This guide explains how to view the current user, create and delete users and groups, modify passwords and account settings, and manage file permissions with chmod and ownership with chown, providing detailed command syntax and practical examples for Linux system administration.
This guide explains how Linux stores user and group information in /etc/passwd, /etc/shadow, /etc/group, and /etc/gshadow, and provides detailed command examples for adding, modifying, locking, and deleting users and groups, as well as managing passwords and shell access.
This guide explains how to view the current user, create and delete users and groups, modify passwords and group memberships, and control file permissions on Linux using commands such as whoami, adduser, usermod, groupadd, chmod, and chown.
This article explains the new MySQL 8.0 features for user and role management, including changes to authentication plugins, password encryption, dynamic SET PERSIST configuration, password expiration and reuse policies, and detailed SQL examples for creating users, granting privileges, and managing roles.
This comprehensive guide explains Linux user and group management, covering essential files such as /etc/passwd, /etc/shadow, and /etc/group, detailing each field, and providing step‑by‑step command examples for adding, modifying, locking, and deleting users and groups, as well as managing passwords and group administrators.
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.
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.
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.
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.
This guide details how to build an isolated internal network using a bastion host, configure port forwarding, synchronize time via NTP, and manage Linux users with scripts, disk quotas, login time restrictions, and process termination commands.
This guide explains why absolute security is impossible, describes common attack vectors against SSH, and provides step‑by‑step techniques for disabling root logins, configuring sudo, creating private service users, tightening file permissions, and removing unused accounts to harden Linux servers.
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.
This guide walks you through installing MariaDB via binary packages, explains its configuration file hierarchy, demonstrates essential client and server commands for data definition and manipulation, and details how to create users and manage their privileges effectively.
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.
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.
Learn the essential concepts of Linux user and group management, including user types, the structure of /etc/passwd and /etc/shadow, group definitions, permission inheritance, and practical commands such as useradd, usermod, groupadd, and userdel for creating, modifying, and deleting accounts.
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.
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.
