Mailchimp Popup on homepage only with is (front_page) [closed]

You have a couple problems. First, the ! in the conditional means “NOT.” Secondly, the || means “OR”.

In other words, your conditional translates to:

If this is NOT the front page OR this is NOT the post archive page

That describes every page. Try this instead:

<?php if ( is_front_page() ) :?>
    <script id="mcjs">!function(c,h,i,m,p){m=c.createElement(h),p=c.getElementsByTagName(h).
            [0],m.async=1,m.src=i,p.parentNode.insertBefore(m,p)}
        (document,"script","https://chimpstatic.com/mcjs-
        connected/js/users/bb98175c14cd48aeb0879ecff/.....js");</script>
<?php endif; ?>

This says “If this is the front page, output the following code”

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