Skip to content

Latest commit

 

History

History
40 lines (20 loc) · 1.41 KB

README.md

File metadata and controls

40 lines (20 loc) · 1.41 KB

ORM - Hibernate

Database - MySQL (8.0.21)

###Installation/Configuration:

  1. Installation for MySQL on OSX/Windows:

    https://dev.mysql.com/doc/mysql-osx-excerpt/5.7/en/osx-installation-pkg.html

  2. Installation of MySQL Workbench on OSX/Windows:

    https://dev.mysql.com/downloads/workbench/

  3. MySQL configuration (please use this password while installing MySQL):

    Hostname: localhost, Port: 3306, Username: root, Password: 12345678 (or the one given by you during installation in #1)

  4. MySQL schema:

    Create new schema milestone4 in MySQL Workbench (Right click in Left Pane near sys, and select Create new schema)

  5. MySQL scripts (before launching Fx Application):

    Go to src/main/resources/scripts -> Run CREATE_TABLES.sql and then Run CONSOLIDATED_INSERTS.txt in serial order

  6. JDK Used - 1.8

    JavaFx comes along till JDK 1.8, if you use advanced versions, you need to install JavaFx separately

###Common Issues

  1. OSX - mysql-8.0.21-macos10.15-x86_64.pkg” can’t be opened because Apple cannot check it for malicious software.

    If you see above error while installing MySQL on OSX, go to System Preferences > Security & Privacy > General > Click Open Anyway

  2. OSX - MySQL is installed but is not starting.

    Use MySQL Preference Pane (https://dev.mysql.com/doc/mysql-osx-excerpt/5.7/en/osx-installation-prefpane.html) to Start MySQL server.