DB Error: connect failed (bad password?)

After reading some related topics, I am still having some issues getting past the “DB Error: connect failed”.

I am fairly new at Ubuntu/Linux and am struggling to understand how to set up access to the database.

My Install Data is set up with the following:
DBUSER = “playsms”
DBPASS = “”

I have connected to the mysql database and ran the command “SELECT User FROM mysql.user;” and can verify that the DB user exists. I am not sure how to check what the password is for that user, or how to set it to the as mentioned above.

Any help would be appreciated!