| Computing Setup |
-
Don't Fall Down in Front of the Monster!!!!!
Description: The database installation activity that follows has already proved troublesome for some students. Apparently,
those of us who have installed Version 8 of the MySQL Server are having problems when running the scripts that load
the databases used during class and for your coding assignments. In their orignal state, these scripts contain
statements for creating users, granting permissions, and setting passwords. Unfortunately, changes in Version 8 have caused these
statements to break. Fortunately for us, we don't rely on any of these features in our class. So, I have created
a revised version of the database setup files in which the problem statements have been turned into harmless comments. If you
are using MySQL Server Version 8, you will need to use the revised database setup files that I have provided below rather than
the version that you download from the publisher's site for the text book. Please make this change before you run your database
setup. Otherwise, you will have fallen down in front of the monster.
-
Install MySQL Server Community Edition and MySQL Workbench
Description: Please install MySQL Server Community Edition and MySQL Workbench on your
computer. I have provided two tutorial videos below to help you with the installations.
One video is for Windows 10 users and the other is for macOS users. Both of these videos
were recorded for the Spring 2018 semester. So, the exact versions of software will
have changed since the videos were made. The videos encourage you to install the latest
versions of the available software -- I still support that recommendation. Please note that
when installing the MySQL Version 8 Community server software, you will be asked whether you
want to use the new "password hashing algorithm" or the old one. In my experience, you
will have an easier life if you choose the old one.
|