WordPress ignoring LIMIT / posts_per_page despite being in wp_query

Try adding 'nopaging' => false to your query construct.

I just had the same issue and it fixed it for me.

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)