add user to database

[ourweb]

i know how to add a mysql user from the command line, but how do i add an user to a database with full rights from the command line

[Lyttek]

Umm... that was a simple google search

GRANT ALL ON *.* TO 'new_username'@'localhost';

all privs on all databases, which I assume you don't want, so change the *.* to the database name. (database.*)