Need category header to link to category archive list

Use get_category_link. Your code (relevant part) will look like:

<h2 class="subcats-title">
    <a href="https://wordpress.stackexchange.com/questions/20289/<?php echo get_category_link(38); ?>">
        <?php echo get_cat_name(38); ?>
    </a>
</h2>

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