Start and Stop MySQL Service

//to stop mysql service
[cloudera@quickstart ~]$ sudo service mysqld stop;
Stopping mysqld:

// service stopped already. so it throws error
[cloudera@quickstart ~]$ mysql -uroot -pcloudera
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)


// start mysql service
[cloudera@quickstart ~]$ sudo service mysqld start
Starting mysqld:   


// logon to mysql
[cloudera@quickstart ~]$ mysql -uroot -pcloudera

//import .sql script file with data into mysql to create database and tables
mysql> source /home/cloudera/Desktop/POCs/ds/world.sql


mysql> use world
Database changed
mysql> show tables;
+-----------------+
| Tables_in_world |
+-----------------+
| City            |
| Country         |
| CountryLanguage |
+-----------------+
3 rows in set (0.00 sec)