MySQL

A collection of articles, tutorials, and content related to the MySQL database server.

Server monitoring with Monit on Debian and Ubuntu systems

botond published March 2023, 01, Thu - 26:02 time
Monit is a free and open source process and resource monitoring tool that can be used to monitor system processes and resources using a web browser and command line. Monit automatically stops or restarts processes or services if, for example, they use too many resources or behave abnormally. It also sends email alerts about various events.
On this page, we install the Monit system monitor program on a Debian 10 (Buster) perfect server version 1.1, where it was not used before, and then set it up.

How to protect our server from attacks on our databases with "Access denied for user root@ip address (using password: YES / NO)" using Fail2Ban

botond published 2022/06/05, v - 01:45 time
When we run websites, our server and the websites and services that run on it are often vulnerable to external attacks, and our MySQL / MariaDB database server is no exception. If the Fail2Ban protection software is also available on your server, this short description will show you how to make your server more secure against attacks on your "Access denied for user root @ ip address (using password: YES / NO)" database server.

mysqld (MySQL / MariaDB server)

The mysqld (MySQL / MariaDB server) manual page and help. Mysqld, also known as MariaDB Server, is the main program that does most of the work of a MariaDB. MariaDB Server manages access to the MariaDB data directory, which contains databases and tables. The data directory is also the default location for other information, such as log files and status files.

mysql_upgrade

Manual page and help for the mysql_upgrade linux command. The mysql_upgrade command checks all tables in all databases for incompatibilities with the current version of the MySQL / MariaDB server. Additionally, mysql_upgrade also updates system tables to take advantage of any new privileges or capabilities that may have been added.

Install Ubuntu 20.04 LTS (Focal Fossa) LAMP Server v1.0

botond published Jan. 2020, 10, 21:18 p.m. time
With the help of LAMP systems, we can run dynamic web pages on our server or even on our home computer. I have previously built LAMP servers for Debian 8 (Jessie), Debian 9 (Stretch) and Ubuntu 18.04 LTS (Bionic Beaver), and in this description we will install the LAMP server components for the Ubuntu 20.04 LTS (Focal Fossa) Linux distribution.

Installing Debian 10 (Buster) LAMP Server v1.0

botond published 2019/11/19, k - 14:25 time
With the help of LAMP systems, we can run dynamic web pages on our server or even on our home computer. In this description, we create a LAMP server for Debian 10 (Buster) with the following components: MariaDB 10.3.18, Apache 2.4.38, PHP 7.3 and phpMyAdmin 4.9.1. On this page we install the Apache, MariaDB and PHP components.

How to install Matomo (formerly Piwik) web analytics software on our Apache server

botond published 2019/09/01, v - 16:01 time
In this tutorial, we will install Matomo (formerly Piwik) web analytics system on an existing server, which will then provide us with detailed statistics on visitor traffic to websites running on the server. First, we create the database, storage, and configure the Apache for the system ...