I will keep this short and sweet!
if you want to access all your databases
GRANT ALL ON *.* TO username@'yourhostnameorip' IDENTIFIED BY 'PASSWORD
if you want to access a particular database
GRANT ALL ON databasename.* TO username@'yourhostnameorip' IDENTIFIED BY 'PASSWORD