Introduction

This page is established as a method to view videos that will be used as a guide through your course. This is essentially an additional resource to use in relation to what you’ve learned in class.

Remote Host Identification has changed

When you see a message like below, means that something has altered on your jail account.
Below is how to resolve it.
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
@ WARNING: REMOTE HOST IDENTIFICATION HAS CHANGED! @
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
IT IS POSSIBLE THAT SOMEONE IS DOING SOMETHING NASTY!
Someone could be eavesdropping on you right now (man-in-the-middle attack)!
It is also possible that a host key has just been changed.
The fingerprint for the ECDSA key sent by the remote host is
SHA256:4fAGVdDRLzF4684jEKBL+cyNgy66UxBGuz/qEuz3pEI.
Please contact your system administrator.
Add correct host key in /Users/jseaman/.ssh/known_hosts to get rid of this message.
Offending ECDSA key in /Users/jseaman/.ssh/known_hosts:14
ECDSA host key for username.it.pointpark.edu has changed and you have requested strict checking.
Host key verification failed.

Type the following command into your local prompt via Terminal or Putty.
Use the username that you want to access. For example your host account.
1. ssh-keygen -R username.it.pointpark.edu

Results: # Host username.it.pointpark.edu found
/Users/yourusername/.ssh/known_hosts updated.

mySQL Root Password is locked Fix

When your root@localhost is locked in mySql, follow the steps below on how to resolve the issue.

1. sudo service mysql-server stop
2. sudo - s
3. mysqld_safe -skip-grant-tables &
4. mysql -u root
5. use mysql;
6. describe user;
7. select PASSWORD("newpassword") 
8. update user set authentication_string=PASSWORD("newpassword") where user='root';
9. update user set plugin = "mysql_native_password" where user='root';
10. Flush privileges;
11. sudo service mysql-server start
12. mysql -u root --password
13. Go to: https://it.pointpark.edu/tutorials/mysql/
14. Follow the instructions to setup your environment if it's not setup.

How To Tutorial Videos

How to create a SQL Table:

How to add data to the table:

How to create a Data Model: