rkidder.com

1. Log into the database with root/sa priveleges.

2. Issue the command:

   grant all on database.* to 'username'@'localhost' IDENTIFIED BY 'clear_password';
   
   

Note: It is not necessary to flush priveleges when using the "grant" syntax above.