How do I change the WordPress Address URL only and still login to wp-admin

For anyone else in this dilemma, I took a different approach

I set the origin as cdn.mydomain.com on AWS Cloudfront and added cname www.mydomain.com

all working now 🙂

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