mysql> grant all privileges on bd.* to userbd@host identified by 'password';
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql>
si quisieramos darle todos los permisos a una base de datos para todas las ip's seria asi:
grant all privileges on name_db.* to name_usuario@'%' identified by 'pass';
flush privileges;