DatabaseCategory

Introduction MongoDB is a popular NoSQL database that is used for storing large amounts of data in a flexible and JSON-like format. The Backup and Restore in MongoDB is an important part to handle a database. This utility is important because the valuable data can be removed or crashed or… Continue Reading How to backup and restore a Mongo Database

Introduction Odoo ERP is an online SaaS solution for supporting and integrating business activities such as production planning, manufacturing, logistics, finance, accounting, warehouse management, and human resources. The key benefits of Odoo are: Integrate systems and services. Automate the business process Prerequisite Implementation Step 1: SSH the server  $ ssh… Continue Reading How to reset an Odoo user password in the database

Introduction phpPgAdmin is a free software tool written in PHP, intended to handle the administration of Postgres database over the Web.Prerequisite1. An SSH user with sudo privileges2. A web server has to be installed 3. Postgres Database with their clients has to be installed4. A database and its user with… Continue Reading How to install phpPgAdmin in the remote server – Linux

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… Continue Reading How to enable the slow query log – Mysql in Linux

Prerequisites Credentials to access the Plesk panel SSH root access  Implementation Follow the below steps to install MySQL, Enable remote access to the local MySQL server, and Proxy rule setup in the Plesk panelI. MySQL installation Log into Plesk with the credentials Go to Tools & Settings > Database Servers… Continue Reading How to add Proxy pass rule to access PHPMyAdmin without port number in URL -Plesk

Sometimes, a WordPress user, with one of the following capabilities, such as administrator, editor, author, contributor, or subscriber, forgets its login credentials, especially the password. WordPress passwords can be easily changed via the “Lost Password” WordPress login form. However, if the WordPress account has no way of accessing his email… Continue Reading How to reset the WordPress password in Mysql

Step1: Stopping the MySQL service by using this command systemctl command: Step2: Now, we need to restart the MySQL service. Step3: We have able to connect to the MySQL server as root, without specifying a password. Step4: Now, reset the root password, but first flush the privileges to reload the… Continue Reading How to change My SQL password on Linux

To disable foreign key constraints when you want to truncate a table: Use FOREIGN_KEY_CHECKS and remember to enable it when you’re done:

This can happen for a variety of reasons. Please troubleshoot the issue by following the steps below one by one. 1) Verify the address mysql is bound to, it’s probably 127.0.0.1 (only) which I believe is the default (at least on standard Ubuntu server). You’ll have to comment out the… Continue Reading [ERROR][logstash.inputs.jdbc Unable to connect to database. Tried 1 times {:error_message=>”Java::ComMysqlJdbcExceptionsJdbc4::CommunicationsException: Communications link failure\n\nThe last packet successfully received from the server was 1 milliseconds ago. The last packet sent successfully to the server was 1 milliseconds ago.”}

If the mysqld server receives too many connection requests from the host that is interrupted in the middle, the following error occurs: The max_connect_errors system variable determines the number of successive interrupted connection requests that are allowed. Once there are max_connect_errors failed requests without a successful connection, mysqld assumes that something is… Continue Reading Host host_name is blocked