Creating MySql Database & Setting up users.

Creating mysql Datbase:
1. At mysql command prompt issue command

create database <>;

2. Giving all users access to all the datbases from the server.

GRANT ALL PRIVILEGES ON *.* TO 'user'@'localhost' IDENTIFIED BY 'some_pass' WITH GRANT OPTION;

3. Giving all users access to all the datbases from remote machines. '%' in the query signifies that.

GRANT ALL PRIVILEGES ON *.* TO 'user'@'%' IDENTIFIED BY 'some_pass' WITH GRANT OPTION;

4. VERY VERY IMPORTANT DO NOT FORGET:
FLUSH PRIVILEGES;