This guide explains how to enable or configuring the error log in MySQL® or MariaDB. If MySQL is not logging errors or is saving them in an unexpected location, it…
Tag: MySQL
How to Resolve the ‘MySQL Command Not Found’ error
January 2, 2025 / MySQLThis article explains resolving the “MySQL command Not Found” error. This error usually means that MySQL is not installed on your system or its installation path is missing from the…
How to repair MySQL databases with the Plesk (Onyx) repair utility
July 2, 2024 / MySQLThis guide explains how to repair MySQL Database with the Plesk (Onyx) repair utility. It helps users efficiently check and repair their MySQL database servers by ensuring the integrity of…
How to fix the MySQL1064 error
May 22, 2024 / MySQLThis guide explains how to fix the MySQL 1064 error. It occurs due to incorrect syntax in the SQL query, which may result from typographical errors, the use of reserved…
How to remove MySQL tables, databases and users using CMD
May 1, 2024 / MySQLIn this article, we will explain how to remove MySQL tables, databases, and users using the command line. Follow the steps: Deleting tables and databases- To remove MySQL tables and…
How to check MySQL version
March 27, 2024 / MySQLThis article explains how to check the MySQL version. To check the MySQL version installed on your system, you can use one of the following methods- Using MySQL Command Line Client-…
How to Add Extra MySQL Access Hosts in WHM
December 6, 2023 / MySQLThe MySQL Access Hosts tool within WHM enables you to designate specific hostnames and IP addresses for automatic inclusion across all users and databases on your server. Follow the steps:…
How to create MySQL profiles through WHM
August 24, 2023 / MySQLThis guide explains how to create MySQL profiles through WHM. MySQL profiles control all the data for the linking between the local or remote MySQL server. Root users can create…
How to revoke privileges from a MySQL user
May 9, 2023 / MySQLThis guide explains how to revoke privileges from a MySQL user. The syntax for it would be as follows: REVOKE privilege_type [(column_list)] [, priv_type [(column_list)]]… ON [object_type] privilege_level FROM…
How to check the size of MySQL database using SSH
May 6, 2023 / MySQLIn this article, we’ll go through how check the Size of MySQL Database using SSH Command Line. Follow the steps to check the MySQL database using of SSH: Log into…