Connection string for mysql database and how to write stored procedure in mysql database and use it

Question

To write a stored procedure for login page in MySql database and use that in windows login form.