4.2 Download and install sample database

4.2.1 download

http://www.mysqltutorial.org/wp-content/uploads/downloads/2016/05/mysqlsampledatabase.zip

4.2.2 employee sample database

https://launchpad.net/test-db/, download the second one (full) by right click to save

4.2.3 unzip the tarball

tar -xjf employees_db-full-1.0.6.tar.bz2

refer to this document to install database:

http://dev.mysql.com/doc/employee/en/employees-installation.html

4.2.4 install the sample database

4.2.4.1 install

4.2.4.2. validating the database

time mysql -t < test_employees_sha.sql

4.2.4.3. check the database

Show all databases

switch to employees database and show all tables

read the table employees