Public bug reported: 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 '[email protected]: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 ** Affects: mariadb (Ubuntu) Importance: Undecided Status: New -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/2127679 Title: Internal MariaDB error code: 1045 To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mariadb/+bug/2127679/+subscriptions -- ubuntu-bugs mailing list [email protected] https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
