If you are installing phpScheduleIt on a remote host, please follow these steps. These steps assume you are using cPanel.
Adding the database and user
•Select the MySQL Databases tool
•Add a new user with username and password of your choice. This will be the username and password used in your phpScheduleIt config file.
•Create a new database with whatever name you choose. This will be the name of the database in your phpScheduleIt config file. 'phpSchedlueIt2' is the recommended database name.
•Associate the new user with the new database, giving the user permission to SELECT, CREATE, UPDATE, INSERT and DELETE. Click the 'Add User to Db' button.
Creating tables
•Open phpMyAdmin.
•Click on the database name that you just created in the left panel.
•Click the SQL tab at the top of the page.
•Import "/database_schema/schema-utf8.sql" to phpscheduleit2
•Import "/database_schema/data-utf8.sql" to phpscheduleit2
If you have access to MySQL
•Run/import "/database_schema/create-db.sql" to mysql db (phpscheduleit2 db created)
•Run/import "/database_schema/schema-utf8.sql" to phpscheduleit2 (db schema created)
•Run/import "/database_schema/create-user.sql" to mysql db (schedule_user/password mysql account created to match to your default configuration and notice that this is not the application user!).
At this point with the aforementioned default configuration in your-phpScheduleIt/config/config.php your application can connect to the database and loaded eg. see
http://localhost/your-phpScheduleIt/Web/index.php but you can not login since there is no application data or user, so go to next step
•Run/import "/database_schema/data-utf8.sql" to phpscheduleit2 (initializing application database)
•Optionally - run/import "/database_schema/testdata-utf8.sql" to phpscheduleit2 (sample application data will be created with 2 users: admin/password and user/password). These users are available for testing your installation. (This may not be possible in a hosted environment depending on the settings, if so then just create a new user using the admin email from config, if captcha fails, turn it off)
