In this tutorial, we will guide you through resetting the root password for MySQL 8.0 and MariaDB 10.4. If you are having issues with the root user or are unable to access database due to an authentication error, it’s probably time to reset the password.
Infrastructure
How to Install the Latest Version of curl (7.77.0) on Ubuntu 18.04/20.04 with HestiaCP or VestaCP
The default version of curl on Ubuntu servers is often outdated, and no updated package may be readily available in the repositories. This guide provides step-by-step instructions to install the latest version of curl (7.77.0) on Ubuntu 18.04/20.04, including systems running HestiaCP or VestaCP.
How to Enable the WDDX Extension in PHP 7.4: Installation Guide
WDDX provides a neutral data interchange mechanism that allows the transfer of data between different programming languages, platforms, and systems. Despite its removal, it is still possible to install the WDDX extension manually in PHP 7.4. This guide will walk you through the process.
How to Secure a Memcached Server from UDP Attacks
Memcached is a popular caching system, but if improperly configured, it can be vulnerable to UDP-based attacks. This guide explains how to secure your Memcached server by disabling the UDP protocol and restricting access to local connections.
How to Update MySQLTuner in CWP Control Panel
By tuning MySQL for specific system resources, MySQLTuner helps servers handle larger loads and prevents performance issues. This guide will show you how to update MySQLTuner in the CentOS Web Panel (CWP) to the latest version with simple steps.
How to Import a Large MySQL Database via Command Line on CWP, VestaCP, and cPanel Servers
In this tutorial, we’ll walk you through how to import a large MySQL database on servers running CWP (Control Web Panel), VestaCP, or cPanel. We’ll also explain how to handle database backups, especially when they are archived in formats like .zip or .gzip.
How to Install Apache DSO mod_php and Zend OpCache with PHP 5.6/7.0/7.1/7.2 on CentOS Web Panel (CWP)
This guide explains the process of enabling Apache DSO mod_php and Zend OpCache on CentOS Web Panel (CWP). Using Apache mod_php (DSO) significantly enhances performance, especially for high-traffic sites.
How to Optimize Apache, PHP, and MySQL Performance for a 1GB RAM VPS
Managing a VPS with only 1GB of RAM requires careful optimization to ensure smooth performance and avoid issues like out-of-memory (OOM) errors. While 1GB of RAM is sufficient for running a single application, tuning your stack—Apache, PHP, and MySQL or MariaDB—can maximize performance.
Speed Up WordPress with Memcached on PHP 7
Memcached is a high-performance, distributed memory object caching system designed to speed up dynamic web applications by reducing database load. It works by storing small chunks of arbitrary data, such as strings or objects, which can include results from database queries, API calls, or page rendering.
How to Create and Add Swap Space on Linux (CentOS, Ubuntu, CWP, and VestaCP)
Adding swap space is a practical solution to enhance the stability and performance of Linux servers, especially those with limited physical memory. Swap acts as an overflow for RAM, helping to prevent out-of-memory errors, system crashes, and server hangs.