Create database in mysql

Its very simple,

mysql>mysql> mysql -u root -p  (Press Enter)

mysql>mysql> create database attaakwal;     (Press Enter)

To create User:
mysql>GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost' IDENTIFIED BY 'password';

mysql>flush privileges;

when created It shows
Query OK, 1 row affected (0.03 sec)