Re: Databases are not showing up on Replicated Server

[Lib Tech]

Here is the content of the log file.

2024-07-25T00:37:07.629454Z 40 [Warning] [MY-010897] [Repl] Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
2024-07-25T00:37:07.693387Z 42 [ERROR] [MY-010584] [Repl] Replica SQL for channel '': Worker 1 failed executing transaction 'ANONYMOUS' at source log mysql-bin.000001, end_log_pos 483; Error 'Operation ALTER USER failed for 'replica'@'192.168.1.112'' on query. Default database: ''. Query: 'ALTER USER 'replica'@'192.168.1.112' IDENTIFIED WITH 'caching_sha2_password' AS '$OMETHING$=>I&h)g 5N(q<thimightbeahashedpassword'', Error_code: MY-001396
2024-07-25T00:37:07.694789Z 41 [ERROR] [MY-010586] [Repl] Error running query, replica SQL thread aborted. Fix the problem, and restart the replica SQL thread with "START REPLICA". We stopped at log 'mysql-bin.000001' position 157
2024-07-25T00:37:07.696581Z 40 [System] [MY-014001] [Repl] Replica receiver thread for channel '': connected to source 'replica@192.168.1.212:3306' with server_uuid=iupdateduuidwithfakecharacters, server_id=1. Starting replication from file 'mysql-bin.000004', position '1348'.