how to show all type of author posts in author page (SOLVED)

If you use WordPress author template to show user posts ( example.com/author/{user_name} ) the best solution will be to change the main query via the pre_get_posts filter hook.

function se339534_author_any_post_types $query ) {

    // apply changes only for author archive page
    if ( ! is_author() || ! $query->is_main_query() )
        return;

    $query->set('post_type', 'any');
}
add_action( 'pre_get_posts', 'se339534_author_any_post_types' );

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