Дать права пользователю [user] на базу [database] с паролем [password]:

mysql> grant all privileges on [database].* to '[user]'@'localhost' identified by '[password]';
mysql> flush privileges;