Add new users to a MySQL Database

# create the user paul and give him full

# permissions on the new database

mysql> grant CREATE,INSERT,DELETE,UPDATE,SELECT on pauldb.* to paul@localhost;

 mysql add user to database