Internal MariaDB error code: 1045
| Affects | Status | Importance | Assigned to | Milestone | |
|---|---|---|---|---|---|
| mariadb (Ubuntu) |
New
|
Undecided
|
Unassigned | ||
Bug Description
Setting up replication between two Virtualbox identical Unbuntu 24 (Noble) server with mariadb Ver 15.1 Distrib 10.11.13-MariaDB, for debian-linux-gnu
With the following fillings of the 50-server.cnf from the master:
[server]
user = mysql
pid-file = /run/mysqld/
socket = /run/mysqld/
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
lc-messages-dir = /usr/share/mysql
bind-address = 10.56.10.45
query_cache_size = 16M
log_error = /var/log/
log_bin = /var/log/
log_bin_index = /var/log/
relay_log = /var/log/
relay_log_index = /var/log/
[mysqld]
server-id = 1
rpl_semi_
rpl_semi_
rpl_semi_
report_host = master
innodb-
innodb-
innodb-
character-
character-
collation-server = utf8mb4_unicode_ci
[mysql]
default-
and slave:
[server]
user = mysql
pid-file = /run/mysqld/
socket = /run/mysqld/
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
lc-messages-dir = /usr/share/mysql
bind-address = 10.56.10.49
query_cache_size = 16M
log_error = /var/log/
log_bin = /var/log/
log_bin_index = /var/log/
relay_log = /var/log/
relay_log_index = /var/log/
[mysqld]
rpl_semi_
server-id = 2
report_host = backup0
innodb-
innodb-
innodb-
character-
character-
collation-server = utf8mb4_unicode_ci
[mysql]
default-
after this created the replusr
CREATE USER 'replusr'
GRANT REPLICATION SLAVE ON *.* TO 'replusr'
CREATE USER 'replusr'
GRANT REPLICATION SLAVE ON *.* TO 'replusr'
CREATE USER 'replusr'@'Backup0' IDENTIFIED BY 'Compare';
GRANT REPLICATION SLAVE ON *.* TO 'replusr'@'Backup0' IDENTIFIED BY 'Compare';
CREATE USER 'replusr'@'Master' IDENTIFIED BY 'Compare';
GRANT REPLICATION SLAVE ON *.* TO 'replusr'@'master' IDENTIFIED BY 'Compare';
GRANT ALL PRIVILEGES ON *.* TO 'replusr'@'master' IDENTIFIED BY 'Compare';
GRANT ALL PRIVILEGES ON *.* TO 'replusr'@'backup0' IDENTIFIED BY 'Compare';
GRANT ALL PRIVILEGES ON *.* TO 'replusr'
GRANT ALL PRIVILEGES ON *.* TO 'replusr'
FLUSH PRIVILEGES;
give me this is the error.log after restart the mariadb with sudo systemctl restart mariadb.service
2025-10-11 1:13:00 5 [ERROR] Slave I/O: error connecting to master 'replusr@
using the next sentence in a ssh connection from slave (10.56.10.49) to master (10.56.10.45):
openbravo@
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 3333
Server version: 10.11.13-
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]>
is working

As extra things:
GRANT only slave replication then it is not possible to login
For me is missing the rights a slave replication user has to full-fill his task to replicate all tables and databases.
Does all rights include for the slave replication GRANT to make that possible and don't need to use GRANT ALL PRIVILEGES ON ?
Documentation about Mariadb is there but most is repeating and copy from a other source and questions like I ask now, are not documented