Getting started with MySQL

One of the easiest ways to learn and work on SQL is using MySQL database.

What is MySQL:

MySQL is the most popular Open Source Relational Database Management System.

MySQL is one of the best RDBMS being used for developing various web-based software applications.

MySQL is developed, marketed and supported by MySQL AB, which is a Swedish company.

MySQL works on many operating systems and with many languages including PHP, PERL, C, C++, JAVA, etc.

Connecting to MySQL Server from CLI:

You establish the MySQL database using the MySQL binary at the command prompt.

-u > MySQL userid created by DBA for the users

-p > Password to connect to MySQL server as given by DBA to the users

-h > Hostname where MySQL Server is running. Not needed if server is running on the local machine.

Password can also be given in same command by putting the password just after -p without any spaces.

To exit, type exit and Enter:

mysql> exit

From Lab -> MySQL Credentials, get your userid, password and hostname for MySQL. https://cloudxlab.com/my-lab#mysql-credentials

Open a new terminal and submit below command after putting in correct values:

mysql -u sqoopuser -pNHkkP876rp -h cxln2.c.thelab-240901.internal

Please note that the mysql username and password are different from your lab credentials which can be seen along with the Jupyter console.

You will get a MySQL prompt. Run a simple SELECT statement on the prompt.

SELECT "Hello World";

Loading comments...