SQLZOO, Create a new user.

MySQL
Give the new user permission to connect and to create their own tables etc.	--The foolowing doesn't work since 5.0 --INSERT INTO mysql.user (user, host, password) --VALUES ('scott', 'localhost', PASSWORD('tiger')); CREATE DATABASE scott; GRANT SELECT, INSERT,UPDATE,DELETE,CREATE,DROP ON scott.* TO scott@localhost IDENTIFIED BY 'tiger'; FLUSH PRIVILEGES;
Specific to MySQL

SQLzoo.net