The following sums how to create a new database and give a user appropriate rights via the mysql command line client:
# # 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 pauldb; 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 pauldb.* to paul@localhost; Query OK, 0 rows affected (0.00 sec) # # Next we set a password for this new user # mysql> set password for paul = password('mysecretpassword'); Query OK, 0 rows affected (0.00 sec) # # Cleanup and ext mysql> flush privileges; mysql> exit;