MySQL Add Users to Database

#
# Connect to the local database server as user root
# You will be prompted for a password.
#
mysql -h localhost -u root -p

#
# Now we see the 'mysql>' prompt and we can run
# the following to create a new database called dummydb.
#
mysql> create database dummydb;
Query OK, 1 row affected (0.00 sec)

#
# Now we create the user dummyuser and give him full
# permissions on the new database
mysql> grant CREATE,INSERT,DELETE,UPDATE,SELECT on dummydb.* to
dummyuser@localhost;
Query OK, 0 rows affected (0.00 sec) 

or

mysql> grant ALL PRIVILEGES on dummydb.* to dummyuser@localhost;
Query OK, 0 rows affected (0.00 sec) 

#
# Next we set a password for this new user
#
mysql> set password for dummyuser@localhost = password('mysecretpassword');
Query OK, 0 rows affected (0.00 sec)

#
# Cleanup and ext
mysql> flush privileges;
mysql> exit;