How to get 'out' or 'return' value from a stored procedure

I have my connection set up. My sql procedure works, but I don't know how to access either a return or out value.//MYSQL ProcedureCREATE DEFINER=root@localhost PROCEDURE password_validation(IN user_password varchar(255), INpassword_confirmation varchar(255), OUT valid bool, OUT description varchar(255))BEGIN IF (user_password != password_confirmation) then set Valid = false; set Description = 'Passwords do not match'; return 'Bad'; ELSEIF (user_password RLIKE '[0-9]' And LENGTH(user_password) >= 8 ) then set Valid = true; set Description = 'Valid Password'; return 'Good'; ELSE set Valid = false; set Description = 'Password must be at least 8 characters, have at least 1 number'; return 'Bad'; END IF; END //NodeJSapp.post('/signup', urlencodedParser, function(req,res){ let sql = "Call password_validation(?, ?, @valid, @description);"; db.query(sql, [req.body.password, req.body.confirm_password], function(err, rows){ if (err){ console.log(err); } else{ console.log(rows) } }) }); }

Submitted February 14, 2019 at 06:58PM by ortz3