How to Fix Error Code 1054 Unknown Column in MySQL

Simple steps on how to fix error 1054 unknown column in MySQL.

As a free, open-source relational database that can cover a lot of use cases, from dynamic web-based discussion boards and blogs to enterprise resource planning software, MySQL has attracted a lot of users and developers over the years. As its name implies, MySQL uses SQL … Read more

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 … Read more

How To Reset Root Password on MariaDB v10+

If you have been using the MySQL database server for a long time, you might be a little confused when you switch to MariaDB. Especially in terms of resetting root password, even though we know that MariaDB is a drop-in replacement for MySQL database server. … Read more

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 … Read more