Unfortunately, it’s not possible to do that using read directly. You will need to ask for input twice and then check if they match:

read -sp "What's your DB user password?" dbuserp
read -sp "Please confirm your DB user password:" dbuserp_conf
if [ "$dbuserp" != "$dbuserp_conf" ]; then
    # passwords do not match
fi