First, login your server as root. Next, type in this :
mysql -u root -p mysql
after that it will ask your mysql root password, key in your mysql root password and press enter
Now on the mysql prompt type:
> grant all privileges on DATABASE_NAME.* to USERNAME@localhost identified by 'PASSWORD';
> flush privileges;
> \q
You are done 🙂