TIFIED BY 'secret';
mysql> grant all privileges on db_name.* to user@'%' ;
A user for backup only :... IDENTIFIED BY 'password';
REVOKE ALL PRIVILEGES ON *.* FROM 'backup'@'localhost';
REVOKE GRANT OPTION ON *.* FROM 'backup'@'localhost';
GRANT SELECT, LOCK TABLES ON *.*
TO 'backup'@'localhost'
WITH
ing steps:
* Get a listing of binary log files on the primary by running **SHOW BINARY LOGS**.
* ... onnement: Docker ====
Avec MariaDB 10.3 (défault on deian 10.8).
Un p'tit docker-compose pour se cré... Slave SQL: Could not execute Write_rows_v1 event on table mysql.user; Duplicate entry 'localhost-root... B error code: 1062''
==== Démarrer le tout ====
On lance les services
<code bash>
docker-compose up