Adding new users to MySQL Databases

Got this one from one of the Debian sites out there with modification on the SET PASSWORD part.. :) # 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 for Paul.
#
mysql> create database skypage;
Query OK, 1 row affected (0.00 sec)

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

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

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