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

To use nyse database

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

If you are facing any issue or for more Information on this please go through below video:


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.


1 Like
Mysql login fails
MySQL not working, throwing Got error 28 from storage engine errors
Unable to login to hr database
Cygwin No Access & No Sqoop on Console
Not able to login to mysql
MySQL Connection from console
I am not able to login into mysql with provided username and password
MySQL - Access denied for all - hr_export/retail_export/h1b_export/hr_user/retail_user/h1b_user
Unable to connect to mysql DB using Sqoop
Unable to read data from order_items_nopk table using sqoop
Cannot connect to SQL
Labs not working! This is second time in 3 days? :((
What is the password for retail_user user for mysql
What is the password for retail_user user for mysql
SQL connection error
Not able to connect mysql database
Access denied connect to mysql
In mysql - retail_export database is missing
Not able to connect to retail_user data base
Apache sqoop error
Mysql Credentials
Unable to run sqoop on gw02.itversity.com
Not able to connect to mysql db
Big data Lab information
MySQL-Sqoop Details
unable to login to mysql
List of tables of retail_export in lab
MYSQL connection issue loading
Need to access mysql workbench to create stored procedures
Sqoop export ,table not found exception
Cannot connect labs MySQL tables from DBeaver
Access denied to retail_db
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
Unable to use the database
Lab information needed
Query is not running in Mysql server in itversity - labs
Cannot login to mysql user hr_user in lab
Access Mysql via ITVLAB
How to access SQL console in itversity lab
Am a new user,Unable to connect to mysql for go2.itversity.com
My sql and sqoop connection string
How to connect to mysql in ITVERSITY new labs
About the Common Issues category
How to connect MySQL in spark-shell/pyspark?
Unable to create database and tables in MySQL
Access denied for mysql
Cannot access mysql from itversity console

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

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