This article illustrates how to prevent users from viewing all Microsoft SQL databases as the users with basic public access can often view a list of all databases on the…
Tag: MySQL
How to Optimise MySQL Performance using MySQLTuner
February 10, 2025 / MySQLMySQL performance optimisation is crucial for ensuring database efficiency, stability, and speed. MySQLTuner is a powerful script that analyses your MySQL server’s configuration and provides recommendations for performance improvements. This…
How to Check and Repair a Corrupted MySQL Database Table Using SSH
November 18, 2024 / MySQL Sales FAQThis guide explains how to use MySQLcheck to repair a corrupted database table. Checking and repairing a corrupted MySQL database table using SSH ensures the integrity of the database, stopping…
How to export/import a MySQL database through SSH
November 6, 2024 / MySQLIn this article, you will learn how to export and import a MySQL database via SSH. For databases larger than 128MB, using SSH is recommended for the export/import process. …
How to Fix “MySQL Command Not Found” Error
June 14, 2024 / MySQLThis guide illustrates how to fix the “MySQL Command Not Found” error. MySQL is an open-source database management system (DBMS) that is well-matched with Linux, Windows, and MacOS. Sometimes you…
How to convert dmp file to mysql database
May 9, 2024 / Sales FAQThis article illustrates how to convert dmp file to mysql database. Converting a DMP (dump) file to a MySQL database involves a series of steps, but it is usually done…
How to configure MySQL on master node
April 8, 2024 / MySQLThis guide explains how to configure MySQL on Master Node. By default, MySQL listens on the localhost and does not allow connection from the remote system. Therefore, you will need…
Find Your MySQL Version on Windows – Quick Guide
March 12, 2024 / MySQLIn this guide, we will explain how to check the MySQL version on Windows. Checking the MySQL version on Windows is crucial for ensuring compatibility, security, and effective troubleshooting of…
How to connect to a MySQL database remotely
March 4, 2024 / MySQLThis guide outlines the process of creating a user on your MySQL® server to enable remote connections to a MySQL database. Please note that the instructions provided here are for…
How to eliminate a MySQL user using SSH
January 22, 2024 / MySQLRemoving a MySQL user via SSH is detailed in this guide, where a MySQL user, recorded in the USER table of the MySQL server is deleted along with its linked…
How to increase MySQL database upload limit in PhpMyAdmin from cPanel
January 8, 2024 / cPanel & WHMThis article instructs you to increase the MySQL database upload limit in PhpMyAdmin from cPanel. Increasing the MySQL database upload limit in PhpMyAdmin from cPanel allows users to upload larger database…
How to repair a MySQL database via cPanel
August 28, 2023 / MySQLIn this article, we will help you in the process of MySQL database repair within cPanel. Follow these steps to fix your MySQL database in cPanel: Log into your “cPanel…
How to add MySQL access hosts in WHM
August 15, 2023 / MySQLThis article will explain how to add MySQL access hosts in WHM. WHM allows you to specify specific hostnames and IP addresses for automatic inclusion across all users and databases…
How to copy a MySQL database using phpMyAdmin
June 22, 2023 / MySQLIn this article, we will describe how to copy a MySQL database with the help of phpMyAdmin. Follow these steps to copy a MySQL database using phpMyAdmin: Log into your…