How would I go about pulling the most popular (most used) categories?

You can order by count to order them by the number of posts they are attached to. Use number to limit the number of terms returned:

wp_list_categories( [
    'orderby' => 'count',
    'order' => 'DESC',
    'number' => 5
] );

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