Yep, that user was created and added to the phpScheduleIt db using phpadmin.
If i run the SQL script in phpadmin to add the db structure, do i still need to run the install, or can i simply just run the app. i have tried doing both and both haven't worked.
If the setup.sql contents were run through phpMyAdmin, then you will be ready to go. You should not run the install script after this. If it is not working yet, I'd suggest dropping the database and starting over, following the remote host install instructions.
Here are the instructions again. Remember that you will need modify the config.php file correctly and register the admin user.
Connect to your remote host's control panel, cPanel.
Adding the database and user
1. Select the MySQL Databases tool
2. Add a new user with username and password of your choice. This will be the username and password used in your phpScheduleIt config file.
3. Create a new database with whatever name you choose. This will be the name of the database in your phpScheduleIt config file. 'phpSchedlueIt' is the recommended database name.
4. 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 the tables
1. Open phpMyAdmin.
2. Click on the database name that you just created in the left panel.
3. Click the SQL tab at the top of the page.
4. Open install/setup.sql, in your phpScheduleIt directory.
5. Copy all text starting right after the line 'use phpScheduleIt;' and ending at the line just before 'grant select, insert, update, delete' and paste it into the Run SQL textbox.
6. Click the 'Go' button.
Your database, user and tables are now created. Please make sure that the name of the database and user in your config file match what you just created. Many times, an ISP will prefix your database name or cut is short. Please check the created database name and copy that into your config.php file.