title: Creating a procedure in mySql with parameters
body: <p>I am trying to make a stored procedure using mySQL. This procedure will validate a username and a password. I'm currently running mySQL  5.0.32 so it should be possible to create procedures.</p>
  
  <p>Heres the code I've used. All I get is an SQL syntax error. </p>
  
  <pre><code>   GO
      CREATE PROCEDURE checkUser
      (IN @brugernavn varchar(64)),IN @password varchar(64))
      BEGIN
      SELECT COUNT(*)  FROM bruger WHERE bruger.brugernavn=@brugernavn AND bruger.pass=@Password;
      END;
  </code></pre>
  
  <p>Thank you in advance</p>