Just in case you want to run the database from your machine:
- Change the database password in the code to your SQL password.
- Make a schema in mySQL called groupfive.
- Create a table called user
- Here is the code:
CREATE TABLE
groupfive.user(userIdint(10) unsigned NOT NULL AUTO_INCREMENT,firstNamevarchar(255) DEFAULT NULL,lastNamevarchar(255) DEFAULT NULL,emailvarchar(255) DEFAULT NULL,addressvarchar(255) DEFAULT NULL,cityvarchar(255) DEFAULT NULL,statevarchar(255) DEFAULT NULL,zipcodevarchar(255) DEFAULT NULL,passwordvarchar(255) DEFAULT NULL, PRIMARY KEY (useruserId), UNIQUE KEYemail(email) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;