MariaDB – le fork communautaire du serveur MySQL – est une brique logicielle essentielle pour l’hébergement d’un grand nombre d’applications web. Dans ce premier volet d’articles sur MariaDB, nous allons voir l’installation et la configuration initiale du serveur de bases de données sous Rocky Linux 8.

Knowledge Base » MariaDB Server Documentation » MariaDB Administration » Getting, Installing, and Upgrading MariaDB » Upgrading MariaDB

TL;DR

mariadb-upgrade
#or
mysql_upgrade

Two Methods for mysql to Clean binlog Logs Correctly

Use binlog_expire_logs_seconds to set the expire time (expire_logs_days is deprecated).

By default, remote access to the MySQL database server is disabled for security reasons. However, sometimes you need to provide remote access to database server from home or a web server. This post will explain how to setup a user account and access a MySQL server remotely on a Linux or Unix-like systems.

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';