Skip to content

MySQL 8.4.5 Error -> show slave status #1608

@binaryelites

Description

@binaryelites

While running gh-ost on MySQL 8.5.4 with version 1.1.7 we are getting the below issue:

2025-11-23 17:21:34 INFO starting gh-ost 1.1.7 (git commit: d5ab048)
2025-11-23 17:21:34 INFO Migrating db_trust.app_user_activity_log
2025-11-23 17:21:34 INFO inspector connection validated on localhost:3306
2025-11-23 17:21:34 INFO User has SUPER, REPLICATION SLAVE privileges, and has ALL privileges on db_trust.*
2025-11-23 17:21:34 INFO binary logs validated on localhost:3306
2025-11-23 17:21:34 INFO Restarting replication on localhost:3306 to make sure binlog settings apply to replication thread
2025-11-23 17:21:34 ERROR Error 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'slave status' at line 1
2025-11-23 17:21:34 INFO Inspector initiated on localhost.localdomain:3306, version 8.4.5
2025-11-23 17:21:34 INFO Table found. Engine=InnoDB
2025-11-23 17:21:34 INFO Estimated number of rows via EXPLAIN: 181920998
2025-11-23 17:21:34 INFO Recursively searching for replication master
2025-11-23 17:21:34 ERROR Error 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'slave status' at line 1
2025-11-23 17:21:34 INFO Tearing down inspector
2025-11-23 17:21:34 FATAL Error 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'slave status' at line 1

Tried with 1.1.6, still the same issue persists.

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions