Add new users to a MySQL Database

by admin on December 20, 2007

# 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;