898 private links
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';