Restart MariaDB-Replication on the replica client

Here’s a quick guide on how to log in to MariaDB as the root user from the command line and restart the replication:

Open your terminal and enter the following command:

# mysql -u root -p

sudo is eventually required if you need elevated privileges.
-u root specifies that you want to log in as the root user.
-p prompts you to enter the password for the root user.

Enter your root password when prompted.
After entering the command, you’ll be asked to input the root password. Type the password and press Enter (note that the password will not be visible as you type).

You should now be logged in to MariaDB as the root user.You’ll see a MariaDB [(none)]> prompt, indicating you’re in the MariaDB shell and type the following commands (after every line hit the Enter key):

MariaDB [(none)]> STOP SLAVE;
MariaDB [(none)]> SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1;
MariaDB [(none)]> START SLAVE;
MariaDB [(none)]> QUIT;