1. Home
  2. Database Servers
How to fix error when starting MongoDB service

Fixing “failed to start mongod.service: unit mongod.service not found” Error in MongoDB

MongoDB is a popular database engine used in conjunction with various scripting languages, particularly Python and Rails. Its strongest point is JSON-like data storage, which allows for the natural processing of data stored in the database. The query used by MongoDB is also in the form of JSON, which allows users to construct complex queries …

MySQL

MySQL Error: Access denied; you need (at least one of) the SUPER privilege(s) for this operation

This annoying errors happened to our team few days ago when we were trying to migrate a site from one Linux server to another. So on the current server we compressed all the website files into tar.gz archive and the dump the MySQL database using mysqldump command. Ran wget on the new server to download …

How To Disable MySQL Validate Password Plugin on VestaCP CentOS 7

This tutorial will guide you on how to disable MySQL Validate Password Plugin on VestaCP CentOS 7. The MySQL validate password plugin is intended to improve security on the MySQL database server by requiring an account password and enabling strength testing for potential passwords. This plugin has also a set of system variables that allow …

How To Reset MySQL Root Password on Debian/Ubuntu & CentOS

On this tutorial we will guide you how to reset MySQL root password on Fedora/RHEL/CentOS and Debian/Ubuntu server. This guide should work well on MySQL 5.5, MySQL 5.6, MySQL 5.7 and later versions. In certain conditions it may require us to reset the MySQL root password, for example we want a stronger MySQL root password …

MySQL

How To Fix MySQL Plugin ‘auth_socket’ is not loaded”

When we installed and configured VestaCP with the Ubuntu 18.04 LTS server we got a serious error message with the MySQL 5.7 database server. This error message was clearly seen after the initial installation process of VestaCP was completed, where we had a problem when configuring the database for the web. This problem allows us …

How To Fix MySQLTUNER [!!] Attempted to use login credentials from debian maintenance account, but they failed

MySQLTuner is a script written in Perl that helps us to analyze and configure the MySQL/MariaDB database server in order to get increased performance, stability and balanced server environment. However, under certain conditions we cannot execute the mysqltuner command. That error most often occurs on Debian/Ubuntu systems, where we really can’t run the mysqltuner command. …

How To Upgrade MariaDB v5.5 to MariaDB v10.4 on VestaCP CentOS 7.7

VestaCP is an open source control panel, lightweight and absolutely free. This control panel is designed to be very lightweight which can work seamlessly with Apache web server + Nginx as a reverse proxy, or Nginx web server + PHP-FPM (PHP FastCGI Process Manager). VestaCP also supports almost all Linux operating systems, including RHEL / …