How to view local user password in Terminal?
The passwords are stored in a salted hash, so there is no way to just read them.
If you want to crack the password, here is a guide from a few years ago, it still works.

If you need access to the files in the User profile and you have admin access, you can just change the permissions in finder or using chmod in the terminal. Here is a guide on how to achieve that.