mysql -u root -p 
Enter password:
mysql> GRANT ALL PRIVILEGES ON *.* TO harry@localhost IDENTIFIED BY 'elbomonkey' WITH GRANT OPTION;
mysql>show databases;
mysql>create database sample;
mysql>show databases; 

mysql>exit
mysql -u harry -p
Enter password: elbomonkey
mysql> use sample
mysql>
create table domains (id INT NOT NULL AUTO_INCREMENT,
PRIMARY KEY (id),
domain VARCHAR (20),
sex CHAR (1),
mail VARCHAR (20));