How to access MySQL in Big data labs?



To access MySQL in big data labs use the below commands

To use retail database

mysql -u retail_user -h -p

To use hr database

mysql -u hr_user -h -p

To use h1b database

mysql -u h1b_user -h -p

Common issues we encounter on our state of the art Big Data Cluster with Hadoop, Spark and many others -

This is to simplify our support process so that we can answer technical issues as well.

Unable to create database and tables in MySQL
Cygwin No Access & No Sqoop on Console
Unable to use the database
MySQL not working, throwing Got error 28 from storage engine errors
Lab information needed
Query is not running in Mysql server in itversity - labs
Cannot login to mysql user hr_user in lab
Unable to access Hive and Pyspark
Mysql connection from lab
Sqoop-Access denied issue
Unable to connect Mysql to Tableau online
Whether i am having access for mysql


I follow below steps to access MySQL DB from Itversity big data lab.

[rrajkumar9999@gw03 ~]$ mysql -u retail_dba -h -p


@rrajkumar9999, mysql on will be decommissioned soon.


Mysql hostname and port also hdfs hostname and port number
How to open Hue?
Sqoop running in different gateway: gw01 - how to do it?