o select random rows in MySQL]]
==== Create DB & User ====
mysql> create database db_name ;
mysql> CREATE USER 'user'@'%' IDENTIFIED BY 'secret';
mysql> grant all privileges on db_name.* to user@'%' ;
A user for backup only :
<code sql>
CREAT
ement virtuel:
<code yaml>
#
# Use root/secret as user/password credentials
#
# mariadb official image: ... n conflit de ''PRIMARY KEY'' sur la table ''mysql.user'' peut arrêter la réplication ''[ERROR] Slave SQL... ld not execute Write_rows_v1 event on table mysql.user; Duplicate entry 'localhost-root' for key 'PRIMAR... ve ====
=== Sur le master ===
<code sql>
CREATE USER 'replication-slave' IDENTIFIED BY 'secret';
GRANT