Is there any way of changing the post order via user click?

Check the WP Sort Plugin, it does exactly what you need:

http://wordpress.org/extend/plugins/wp-post-sorting/

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