Internal MariaDB error code: 1045

Bug #2127679 reported by ronald
6
This bug affects 1 person
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/mysqld.pid
socket = /run/mysqld/mysqld.sock
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/mysql/error.log
log_bin = /var/log/mysql/mariadb-bin
log_bin_index = /var/log/mysql/mariadb-bin.index
relay_log = /var/log/mysql/relay-bin
relay_log_index = /var/log/mysql/relay-bin.index

[mysqld]
server-id = 1
rpl_semi_sync_master_enabled = ON
rpl_semi_sync_master_timeout = 1000
rpl_semi_sync_master_wait_point=AFTER_COMMIT
report_host = master
innodb-file-format=barracuda
innodb-file-per-table=1
innodb-large-prefix=1
character-set-client-handshake = FALSE
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci

[mysql]
default-character-set = utf8mb4

and slave:
[server]
user = mysql
pid-file = /run/mysqld/mysqld.pid
socket = /run/mysqld/mysqld.sock
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/mysql/error.log
log_bin = /var/log/mysql/mariadb-bin
log_bin_index = /var/log/mysql/mariadb-bin.index

relay_log = /var/log/mysql/relay-bin
relay_log_index = /var/log/mysql/relay-bin.index

[mysqld]
rpl_semi_sync_slave_enabled = ON
server-id = 2
report_host = backup0
innodb-file-format=barracuda
innodb-file-per-table=1
innodb-large-prefix=1
character-set-client-handshake = FALSE
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci

[mysql]
default-character-set = utf8mb4

after this created the replusr

CREATE USER 'replusr'@'10.56.10.45' IDENTIFIED BY 'Compare';
GRANT REPLICATION SLAVE ON *.* TO 'replusr'@'10.56.10.45' IDENTIFIED BY 'Compare';
CREATE USER 'replusr'@'10.56.10.49' IDENTIFIED BY 'Compare';
GRANT REPLICATION SLAVE ON *.* TO 'replusr'@'10.56.10.49' IDENTIFIED BY 'Compare';
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'@'10.56.10.45' IDENTIFIED BY 'Compare';
GRANT ALL PRIVILEGES ON *.* TO 'replusr'@'10.56.10.49' IDENTIFIED BY 'Compare';
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@10.56.10.45:3306' - retry-time: 60 maximum-retries: 100000 message: Access denied for user 'replusr'@'backup0' (using password: YES), Internal MariaDB error code: 1045

using the next sentence in a ssh connection from slave (10.56.10.49) to master (10.56.10.45):

openbravo@backup0:~$ mysql -ureplusr -pCompare -h10.56.10.45 -P3306
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 3333
Server version: 10.11.13-MariaDB-0ubuntu0.24.04.1-log Ubuntu 24.04

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

Revision history for this message
ronald (gentlerrv) wrote :

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

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.