Public Repository

Last pushed: a year ago
Short Description
This container contains all things needed to do the Hanzehogeschool HBO-ICT1.4wk56 databases course.
Full Description

This container is intended for use by HBO-ICT students of the Hanzehogeschool of Applied Sciences (www.hanze.nl),
to do the weekly exercises stated on Blackboard for week 5 and 6. This already contains the data provided in the importscript on Blackboard.

This container is based on the container wnameless/mysql-phpmyadmin (https://hub.docker.com/r/wnameless/mysql-phpmyadmin/) .
From students for students. The hanze or their teacher had no influence in me making this container, neither I or the Hanze can be held accountable for anything that may happen as result of the use of this container.

How to install:

--- PART 1, Install Docker (if you have not done allready) ---

  1. Unistall VirtualBox (this usually solves most of the installation issues.)
    !!!! YOU WILL PROBABLY LOSE ALL VMS! !!!!
  2. Go to https://www.docker.com/products/docker-toolbox and download the latest version for Windows.
  3. Install docker toolbox with recommended settings.
  4. Start the docker quickstart toolbox, and approve all Windows system dialogs.
  5. When docker is successfull started you will be greeted with a whale "image" .
  6. You can close the terminal, docker will run in the backgrounf

--- PART 2, Install Container ---

  1. Start Kitematic (when docker has not started yet it will start when kitematic has started)
  2. On the first start you can choose to skip the login page. (or create a account)
  3. SEARCH in the top left for: genie137/hanze-1516-db14wk5
  4. When you see the "card" for the container, click CREATE.
  5. Docker will automaticly start downloading the container.
  6. The container will automaticly be started, if this is not the case:
    ^^^^ a. Select the container in the list on the left.
    ^^^^ b. Press START button in the top row.
  7. Click on the SETTINGS tab on the right.
  8. In the opened screen press the PORTS tab.
  9. Check if the ports are the same with the ones I have listed below:
    ^^^^ Docker Port - IP : port - Connection - Description
    ^^^^ 22 - 192.168.99.100 : 32773 - TCP - SSH connection
    ^^^^ 80 - 192.168.99.100 : 32772 - TCP - Webpage connection
    ^^^^ 3306 - 192.168.99.100 : 32771 - TCP - Mysql server connection
  10. The kitematic window can be closed, the container will continue to run.
  11. Stop the container via the same way you started it in step 6 when you shutdown your pc. Just to be safe.
    ^^^^ Usually the container will be stopped automaticly, sometimes this does not work and data will get lost.

--- PART 3, Connecting To Mysql ---

  1. Douwnload and install DBeaver http://dbeaver.jkiss.org/
    ^^^^ You can also use DataGrip or Mysqlworkbench (be aware that this installes much more tools you will never use)
  2. Open DBeaver.
  3. In the menu bar click on Database > New Connection
  4. Select MySQL in the list
  5. In most cases a popup will open, asking you to download driver files.
    ^^^^ Press the DOWNLOAD button in the bottom of that window.
    ^^^^ When done, the window will disappear.
  6. Type in these settings. You may need to enter other ones based on step 09 of part 2. Enter the mysql server connection settings:
    ^^^^ Server Host: 192.168.99.100
    ^^^^ Port: 32771
    ^^^^ Database: funda
    ^^^^ User name: funda
    ^^^^ Password: mysql
  7. Press TEST CONNECTION to test the entered settings.
  8. If successfull, Press next twice, and finish after that.
  9. Doubleclick on the connetion in the left pane.
  10. You can view the tables in the connection using the arrow in front of the connection.
    ^^^^ Go to Databases > funda > Tables
    ^^^^ I've already imported the data.
  11. To open the SQL editor press CTRL+ALT+L or the 7th icon (paper with green plus sign)
  12. To execute the statements press the lightning bolt (whole script or one statement) above the tabs where the editor opened.

--- PART 4, Managing via PHPMYADMIN ---

  1. In your webbrowser go to: 192.168.99.100:32772/phpmyadmin (or else the one determined in step 09 of part 2, use the webpage connection settings)
  2. Login with:
    ^^^^ User name: root
    ^^^^ Password: <leave empty>
  3. You can perform different tasks here. Search google!

-- PART 5, testing with mysqlslap --

  1. Douwnload and Install Putty https://the.earth.li/~sgtatham/putty/latest/x86/putty-0.67-installer.msi
  2. Fill in the IP and Port of the SSH connection determined in step 09 of part 2. Make sure the connection type is SSH.
  3. Click OPEN, when a dialog about a fingerprint occurs (is to enforce security during the connection) press yes.
  4. The terminal asks for a user enter: root
  5. The terminal asks for a password: admin
  6. You can now use the command mysqlslap, you do not have to use sudo when executing an elevated command.
  7. When executing mysqlslap use:
    ^^^^ User: root
    ^^^^ Password: <leave empty>
  8. Other than mysqlslap, you can use other commands here (linux terminal). Search Google!

Good Luck. Leave comments for questions.
Send me coffee via paypal: https://goo.gl/ybwUOE

Docker Pull Command
Owner
genie137

Comments (0)