Introduction The max_connections setting in MySQL defines the maximum number of simultaneous database connections allowed on the server. If this limit is too low, users may face “Too many connections” errors. By default, MySQL sets this value to 151 connections. Prerequisites Before making changes, ensure you have: a. Root access to the server (SSH or ..
Tag : MySQL
Introduction If you are unable to access the WordPress dashboard or need to create a new administrator account manually, you can add a WordPress admin user directly through the database using phpMyAdmin. This method allows you to regain access to your website without using the WordPress login page. Prerequisites Before proceeding, ensure you have the ..
Introduction:MySQL’s slow query log makes it easy to track SQL queries that take more than a specific time for execution. This allows you to find inefficient SQL queries that can be optimized to improve database performance. Prerequisite: Implementation: Step 1: SSH the server with the user having sudo privileges $ ssh user@IP Step 2: Open ..
Introduction cPanel provides an easy way to back up and restore MySQL databases directly from the control panel. Regular database backups help protect website data and simplify recovery during migrations or troubleshooting. Prerequisites Before proceeding, ensure: Implementation I. Backup MySQL Database Step 1: login to cPanel account. Step 2: Select Backup in the Files section of the main page. ..
Introduction: If you need to update the password for a MySQL user account in your cPanel, you can do so quickly through the MySQL® Databases section. Follow the steps below to change the password securely. Step 1: Log in to your cPanel account and select MySQL® Databases under the DATABASES section of the main page. Step 2: ..
Introduction Many Internet Service Providers (ISPs) assign dynamic IP addresses to their customers. Unlike static IPs, dynamic IPs change periodically, which can make remote MySQL access configuration challenging. In certain cases, if only part of the IP address changes, you can configure wildcard rules in cPanel to allow remote MySQL access without updating the IP ..
Introduction Resetting the MySQL root password in WHM (WebHost Manager) is a common administrative task performed when the current password is lost, compromised, or needs to be updated for security reasons. The MySQL root user has full control over all databases on the server, so maintaining its security is critical. WHM provides built-in tools that ..
Introduction: Remote MySQL allows external servers or applications to connect to your database hosted on cPanel. This is useful when your application is hosted on a different server than your database or when you need external access for development, reporting, or integration purposes. This guide explains how to securely configure remote MySQL access using cPanel. ..
Recent Comments