Database Mart Knowledge Base

How to Secure a Linux Server SSH keys, firewall setup, and system updates to harden your Linux VPS or cloud server. How to Secure a Windows Server Apply server protection, configure cloud security, and install antivirus on Windows Server step by step. How to Check if a Linux Server is Hacked Detect suspicious users, abnormal processes, network anomalies, cron jobs, and rootkits on your Linux VPS. How to Check if a Windows Server is Hacked Spot hidden users, abnormal processes, firewall rule changes, and run antivirus scans on Windows Server. Fix IP Abuse Issues from Spam Emails Check your IP reputation, disable spam accounts, clear mail queues, and secure MailEnable, SmarterMail, and Postfix. Fix IP Abuse Issues from Attack or Port Scan Stop port scans, remove spam accounts, and secure your Linux or email server after an IP abuse report. Analyze Postfix Logs with Pflogsumm Install Pflogsumm on Ubuntu or CentOS, parse Postfix logs, and export readable summary reports. Install Windows Defender Antivirus Add Microsoft Defender on Windows Server 2016/2019 and configure baseline protection settings. Print to Local Printer from Remote Desktop Enable and troubleshoot RDP printer redirection so you can print from a remote session to your local printer. Enable Remote Desktop Shadowing Watch or control another user's RDP session on Windows Server 2016–2025, plus Windows 10/11. Install MT4/MT5 on Windows Download and install MetaTrader 4 or MT5 on Windows with tips and beginner-friendly setup instructions. Restrict RDP Access to Specific IPs Use Windows Firewall to allow Remote Desktop only from specific IP addresses on Windows Server. Change Hostname in Ubuntu, Debian, CentOS & Windows Use hostnamectl and equivalent commands to rename your server on major Linux distros and Windows. Change RDP Port on Windows Server Modify the Remote Desktop port via Regedit or PowerShell, update the firewall, and test the new connection. Block an IP in Windows Firewall Block single IPs, multiple addresses, or IP ranges in Windows Firewall using the GUI or PowerShell. Install & Configure a DHCP Server on Windows Add the DHCP role on Windows Server 2019 and set up scopes and client settings from scratch. Publish a Website on a Shared IP Linux VPS Map domains and expose web services on a shared IP using the Database Mart control panel. Configure Port Mapping on DatabaseMart Panel Expose internal services like MySQL to the public internet via port mapping in the control panel. Install Debian 11 Desktop & Enable XRDP Set up a graphical desktop on Debian with XFCE and enable XRDP for remote desktop connections. Change SSH Port in Linux Improve security by changing the SSH port on Ubuntu, Debian, or CentOS, then restart the service. SSH into a Linux Server Using PuTTY Connect from Windows to a Linux server via PuTTY with port 22 configuration for Ubuntu and CentOS. Connect to a Remote Server with VS Code Set up VS Code Remote-SSH to browse, edit, and run code on your remote server like it's local. Fix Sudo Command Errors in Ubuntu Resolve "sudo must be owned by uid 0" and sudoers_policy errors, and repair broken sudo permissions. Install XRDP on Ubuntu Set up Ubuntu Remote Desktop via XRDP, enable RDP, and fix common blue/black screen and auth errors. Install XRDP Automatically on Linux Auto-install and configure XRDP on CentOS, Ubuntu, and Debian for quick remote desktop access. Change Linux User Password Use the passwd command to change or reset any user password, including root, on Linux. Fix Remote Connection Issues to SQL Server Troubleshoot SQL Server remote connection timeouts and get SSMS working again in plain English. Download & Configure MySQL 5.7 for Windows Get MySQL 5.7 installed and configured on Windows Server 2012R2, 2016, or 2019, start to finish. Install phpMyAdmin on Windows Server Install Apache, PHP, MySQL, and phpMyAdmin on Windows Server 2016, 2019, or Windows 10. Backup & Restore a MySQL Database on VPS Use mysqldump and mysql commands to back up and restore MySQL databases on a VPS. Fix MySQL Connection Errors Resolve "MySQL cannot connect" and localhost failures, including firewall rules and root password reset. Connect to a Database Using MySQL Workbench Connect MySQL Workbench to a local or cloud database and troubleshoot common connection failures. Reset MySQL 8.x Root Password on Windows Recover access when you've forgotten the MySQL root password on Windows, step by step. Fix SSMS Slow Startup & Response Speed up SQL Server Management Studio by disabling TCP auto-tuning and RSS in Windows. Upgrade Your SQL Server Version Move safely between SQL Server versions (or Express to Standard) with a pre-upgrade checklist. Backup a Database in SSMS Create a SQL Server database backup in SSMS, covering backup types and recovery best practices. Restore a Database Backup in SSMS Restore from a .bak file in SSMS with options for overwrite, NORECOVERY, and user mapping fixes. Attach & Detach a Database in SSMS Detach and re-attach a SQL Server database (MDF file) in SSMS, including access denied fixes. Enable SQL Server Extension in PHP 7.x Add php_sqlsrv.dll to PHP 7.x, configure php.ini, and test the SQL Server connection. Connect to SQL Server with SSMS Step-by-step SSMS connection guide — authentication options and common troubleshooting for beginners. Install SQL Server Express via PowerShell Use PowerShell to install SQL Server 2019 Express on Windows Server, step by step. Transfer FTP Files with Non-English Filenames Configure UTF-8 charset in FileZilla to handle non-English filenames over FTP without errors. Install & Configure Pure-FTPd on CentOS Download, set up, and configure Pure-FTPd on CentOS 7, including users and firewall settings. Set Up an FTPS Server on CentOS 7 Configure Pure-FTPd with TLS/SSL on CentOS 7 and create an SSL certificate for secure FTP. Solve FTP Connection Errors Fix FTP connection problems: configure passive mode, open firewall ports, and restart FTP services. Fix Pure-FTP GnuTLS Error -110 Resolve the TLS connection not properly terminated error in Pure-FTPd with clear troubleshooting steps. Block Spam Emails in DotNetNuke Stop spam from being sent through your DNN website with step-by-step anti-spam configuration. Install Odoo 14 on Ubuntu Full Odoo 14 setup on Ubuntu 20.04: PostgreSQL, Python3, wkhtmltopdf, and reverse proxy config. Install Node.js on Ubuntu Three installation methods for Node.js on Ubuntu 20.04 — direct download, PPA, or NVM — plus a quick Express.js starter. Install a Joomla Website Upload files, configure the database, and complete Joomla installation for beginners on Windows hosting. Upload & Download Files with FTP over SSL Use FileZilla or CuteFTP with FTPES for secure encrypted file transfers to and from your server. Install WordPress on Windows Server Set up WordPress on Windows Server using IIS and MySQL, step by step for beginners. Install Multiple PHP Versions on Ubuntu Run PHP 5.6 alongside 7.x and 8.x on Ubuntu 18.04 with FPM and Apache, side by side. Configure FastCGI on IIS for PHP Enable FastCGI in IIS to host PHP applications, with every step laid out for first-time hosts. Create a New Website in IIS Add a site, set the application pool, configure bindings, and verify the page loads in a browser. Install FileZilla Server on Windows Set up FileZilla Server, create user accounts, and verify file transfers with the FileZilla Client. Fix "530 Login Authentication Failed" in Pure-FTPd Clear checklist for resolving the 530 login error in Pure-FTPd, covering common auth misconfigurations. Create an FTP Account in Windows Server Add FTP users, configure the FTP server in IIS on Windows Server, and test with FileZilla. Install WordPress on Ubuntu Install WordPress on Ubuntu 22.04 with Nginx and MySQL, step by step for beginners. Update Your WordPress Site Safely upgrade WordPress manually: back up, replace files, and update the database without plugins. Install DotNetNuke (DNN) on Windows Configure SQL database, edit web.config, and complete your DNN installation on Windows hosting. Redirect HTTP to HTTPS in IIS Configure URL Rewrite rules in IIS to force HTTPS and enforce SSL across your website. Install PHP 8.1 for Nginx on Ubuntu Set up PHP 8.1 with Nginx on Ubuntu 20.04, including extensions and a test to confirm it works. Install Nginx on Ubuntu with HTTPS Install Nginx, configure the firewall, and set up HTTPS with Let's Encrypt on Ubuntu 20.04/22.04. Install LEMP Stack on Ubuntu Set up Linux, Nginx, MySQL, and PHP on Ubuntu 20.04 or 22.04 for a secure PHP hosting server. Enable ASP.NET in IIS Switch on ASP.NET 3.5, 4.0, or 4.5 in IIS to host your ASP.NET websites on Windows Server. FTP User Management in cPanel Add and delete FTP users in cPanel with Pure-FTPd via the command line. Install Ollama + Open WebUI on a GPU Server Stand up Ollama and Open WebUI on Ubuntu 22.04 with NVIDIA GPU to chat with local LLMs in a browser. Monitor GPU Utilization with nvidia-smi Track CUDA usage, temperature, and VRAM from the command line using NVIDIA's built-in tool. Access Your Server Console via IPMI Open the remote console on a dedicated or GPU server using IPMI through a browser and Java. Install NVIDIA RTX 4090 Driver on Ubuntu 24 Pick the right driver, install from the command line, and confirm your RTX 4090 is fully recognized. Connect to a VPN on Windows 10 Step-by-step guide to set up and connect to a VPN on Windows 10 with screenshots. Configure Cisco ASA5500 Remote Access VPN Set up remote access VPN on a Cisco ASA5500 using ASDM, with screenshots and beginner-friendly steps. Configure a Site-to-Site VPN on Cisco ASA Set up IKE/IPsec parameters, run the ASDM VPN Wizard, and verify site-to-site connectivity. Install VPN on Windows Server Add the Remote Access role, configure RRAS, and open firewall ports for VPN on Windows Server 2016/2019. Fix MailEnable "Unknown or Disabled User" Error Resolve MailEnable login failures with group policy update and IIS restart steps. Add a Domain & Create Email Accounts in MailEnable Set up a new PostOffice, add a mail domain, and create mailboxes for your users in MailEnable. Install & Configure SmarterMail on Windows Download and configure SmarterMail: admin account, DNS, SMTP auth, and required ports for email services. Remove Your IP from Email Blacklists Check your IP reputation, verify PTR/DKIM/SPF records, and submit removal requests to Yahoo, Gmail, and Hotmail. Add DNS Records for Your Email Domain Set up MX, SPF, DKIM, DMARC, and PTR records to authenticate email and improve deliverability. Configure Gmail SMTP in Moodle Generate a Gmail App Password, configure Moodle's outgoing mail settings, and test email delivery. Set Up Email Forwarding in MailEnable Redirect emails from one MailEnable account to another in just a few steps. Migrate MailEnable to a New Server Transfer MailEnable settings, mailboxes, and configurations to a new server without downtime. Install an SSL Certificate on MailEnable Enable encrypted email on MailEnable by configuring SSL for SMTP, IMAP, and POP3 services. Install MailEnable on Windows VPS Download, install, and configure MailEnable with SMTP and basic security settings on a Windows VPS. Configure & Test SMTP on Windows Server Enable the SMTP service, set it up for outbound mail, and confirm it works on your VPS or dedicated server. Create an Email Signature in MailEnable Add a professional email signature to your MailEnable account with step-by-step instructions. Block an Email Domain in MailEnable Stop spam from specific domains (Gmail, Yahoo, Outlook, etc.) by blocking them in MailEnable. Migrate a Domain in SmarterMail Transfer a domain in SmarterMail to a new server without losing email data. Set Up DKIM on ISPConfig Configure DKIM on Linux with ISPConfig and add the DKIM TXT record to your DNS zone. Stop Spam Emails in MailEnable Configure MailEnable 11 to block spam, prevent unwanted email, and filter junk at the server level. Secure SmarterMail with SSL/TLS Install Let's Encrypt and configure SSL/TLS in SmarterMail to protect all email communications. Configure DKIM & DMARC Signing in SmarterMail Generate DKIM keys, add DNS TXT records, and set up DMARC for reliable authenticated email delivery. Configure Outlook with SMTP Authentication Set up a POP3 email account in Outlook with SMTP authentication and correct port settings. Migrate Email Data to MailEnable Import emails from Gmail, Outlook, or another provider into MailEnable using IMAP or the migration tool. Create MySQL Databases in ISPConfig Create a MySQL database, set up users, and configure permissions in ISPConfig step by step. Install cPanel & WHM on Linux Server Cover installation requirements, run the cPanel install command, and configure it for Linux hosting. Update DNS Records in ISPConfig Manage A, MX, and TXT records in ISPConfig's DNS zone editor for your domains. Create Email Accounts in ISPConfig Set up email accounts and mailboxes for your domain in ISPConfig in a few steps. Install WordPress via ISPConfig Download WordPress, configure MySQL, upload via FTP, and complete installation through ISPConfig. Set Up FTP in ISPConfig with FileZilla Create FTP accounts in ISPConfig, configure FileZilla, and upload or download files from your server. Create a Website in ISPConfig Add and configure a new website in ISPConfig's control panel to get your site live quickly.