SO I think I found my issue after some more digging on stack overflow, but still doing some research on how to fix.
I think my php 7.4 is not pointing to the mysql socket. in my php.ini file I saw this:
[Pdo_mysql]
; Default socket name for local MySQL connects. If empty, uses the built-in
; MySQL defaults.
pdo_mysql.default_socket=
Seems off that pdo_mysql.default_socket= doesnt equal anything....
I will keep you all posted if I find the fix just in case someone else has this issue while upgrading a server.