What are the consequences of having no term limits for executive offices in a democracy?

The news refers to an executive office without a limit. I am curious about the impact of unlimited tenure on governance, accountability, and democracy.