Tags

, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,

Open hortonworks VM

Type “mysql” press enter

mysql>create database demo;

mysql>create user ‘demo’@localhost’ identified by ‘welcome1’;

mysql>grant all priviledges on *.* to ‘demo’@’localhost’;

Above commands will create a database demo.

Also create an user demo with password welcome1.

It will grant all the privileges to the user.

We will use this database for SQOOP exercises later.

Advertisements