Connection details :

hostname : gator4148.hostgator.com

port : 3306

username : sparkdat_user

password : sparkdatabox


user database name  : sparkdat_labs    // Here user will have create/read/delete/drop/truncate/write access

master database name : sparkdat_master // Here user will have only read access .




In master database we have given few tables with millions of records , just copy the data to sparkdat_labs database and you can use the same for your practice like sql, SQOOP and Hive .


To connect mysql using Dbeaver :


Please refer the below link to connect the mysql database using Dbeaver step by step .


https://sparkdatabox.freshdesk.com/solution/articles/48000826981-how-to-connect-mysql-database-using-dbeaver-