How to access MySQL in Big data labs?

bigdatalabs
mysql

#1

To access MySQL in big data labs use the below commands

To use retail database

mysql -u retail_user -h ms.itversity.com -p
password:itversity

To use hr database

mysql -u hr_user -h ms.itversity.com -p
password:itversity

To use h1b database

mysql -u h1b_user -h ms.itversity.com -p
password:itversity


Common issues we encounter on our state of the art Big Data Cluster with Hadoop, Spark and many others - https://labs.itversity.com

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
#2

Venkat,

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

[rrajkumar9999@gw03 ~]$ mysql -u retail_dba -h nn01.itversity.com -p
password=itversity


#3

@rrajkumar9999, mysql on nn01.itversity.com will be decommissioned soon.


#4

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