TIFIED BY 'secret';
mysql> grant all privileges on db_name.* to user@'%' ;
A user for backup only :
<code sql>
CREATE USER 'backup'@'localhost' IDENTIFIED BY 'password';
REVOKE ALL PRIVILEGES ON *.* FROM 'backup'@'localhost';
REVOKE GRANT OPTION ON *.* FROM 'backup'@'localhost';
GRANT SELECT, L
ing steps:
* Get a listing of binary log files on the primary by running **SHOW BINARY LOGS**.
* ... being read by a replica. No log files before this one will be needed.
* If you wish, make a backup o... 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
