Let $w$ be a primitive 5th root of unity. Then the difference equation $$x_nx_{n+2}=x_n-(w^2+w^3)x_{n+1}+x_{n+2}$$ generates a cycle of period 5 for general initial values: $$u,v,\frac{u-(w^2+w^3)v}{u-1},\frac{uv-(w^2+w^3)(u+v)}{(u-1)(v-1)},\frac{v-(w^2+w^3)u}{v-1},u,v, ...$$
For equations of the form $$x_nx_{n+2}=w^{a+b}x_n-(w^a+w^b)x_{n+1}+x_{n+2},\text{ for }w^a+w^b\ne 0$$ with the same globally periodic property, I can show that the only possible periods are 5,8,12,18 and 30.
Curiously, the 'same' equation works for all these periods: $$x_nx_{n+2}=w^5x_n-(w^2+w^3)x_{n+1}+x_{n+2},$$ where $w$ is a primitive $p$th root of unity for $p=5,8,12,18,30$. Is this a fluke or is there a way of seeing why this 'family' of equations always generate cycles?



The substitution $z_n=x_n−1$ really helps us, it leads to the equation $$z_nz_{n+2}=az_{n+1}+b,$$ where $a=-\omega^2-\omega^3, b=1-\omega^2-\omega^3.$ We can easily see that if $z_n=u, z_{n+1}=v$ then $$z_{n-1}=\frac{au+b}{v}, z_{n+2}=\frac{av+b}{u},$$ and $$z_{n-2}=\frac{a^2u+bv+ab}{uv}, z_{n+3}=\frac{a^2v+bu+ab}{uv},$$ so if $a^2=b$ then $z_n$ is $5$-periodic, so and $x_n$. It is true because $$a^2=(\omega^2+\omega^3)^2=2+\omega+\omega^4=1+(1+\omega+\omega^4)=1-\omega^2-\omega^3=b.$$